February 10, 2010 at 4:34 am
Hi,
Are there any way to see "last modified" date on a trigger in sql server 2000 ?
February 10, 2010 at 4:57 am
February 10, 2010 at 5:04 am
wschampheleer (2/10/2010)
Don't have access to SQL2K anymore 🙂 but try the view sys.triggers and look for the column modify_date.
SQL Server 2000 did not have the sys schema, so there is no sys.triggers to check. As for the original question - Unfortunately there isn’t a way to see it in SQL Server 2000
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 10, 2010 at 5:34 am
thanks for ur replies
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply