January 10, 2005 at 5:39 pm
I can't determine if SQL Server stores the "Last Edited" date for objects on the database. The crdate column in sysobjects is obviously the createdate, is there a last edited date stored by SQL Server?
January 11, 2005 at 2:38 am
No, there is no built-in date. I think there are third-party tools that can do this. The crdate is indeed the creation date and it will also serve your purpose as long as your editing consists of DROP and CREATE. If you use ALTER the crdate remains unchanged.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 12, 2005 at 3:49 am
Utilize your source control to store your DDL statements which are changed - then you have a complete audit trail. This is the best method I know - our software incorporates this approach taking any guess work out of database developing, deploying and auditing.
regards,
Mark Baekdal
+44 (0)208 241 1762
Database change management for SQL Server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply