May 16, 2008 at 8:34 am
Hello:
I want to find out any changes done to any DTS jobs or Stored Procedures after a specific date. I can find out all new Created DTS by going through sysdtspackages table or any newly created SP’s by going through sysobjects table and searching on type=’P’ having crdate>’mydate’. However, if someone modifies the SP, crdate is not updated.
Any help would be appreciated.
Thanks,
Ramesh.
May 16, 2008 at 8:48 am
You need DDL Triggers which is new feature of Sql Server 2005.
I am not going in the details here as you can check some book on that or surf web to find good examples.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
May 16, 2008 at 8:51 am
I think i posted my query in wrong topic. I have SQL Server 2000 and not SQL Server 2005.
May 16, 2008 at 9:49 am
So you know you can't use DDL triggers in SQL 2000. Check this thread:
http://www.sqlservercentral.com/Forums/Topic214602-5-1.aspx#bm214606.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply