December 31, 2002 at 3:18 pm
Does SQL Server keep track of the date in which an object is created or modified?
Thanks in advance,
Billy
December 31, 2002 at 3:29 pm
Create date. If you want more than that, you have to roll your own. Either via profiling/auditing, storing the schema for all objects and doing a compare, or by using the new tool Lumigent has that tracks the changes at the transaction log. Typically I don't worry about tracking, Im the only one making changes. If Im out of the office, vacation, whatever, whoever handles things while Im gone copies me on changes applied.
Andy
December 31, 2002 at 3:31 pm
No it does not. But you can use schema_ver and crdate in sysobjects to build something that will track changes.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply