|
Subject:
|
Tracking who is dropping objects
|
|
Posted By:
|
khautinh
|
Post Date:
|
1/10/2007 6:08:14 PM
|
Hi all,
Is there anyway I find some codes that will track who is dropping tables sp, view, UDF and so on?
Thanks a lot
|
|
Reply By:
|
Jeff Moden
|
Reply Date:
|
1/10/2007 7:19:46 PM
|
Not is SQL Server 2000... in SQL Server 2005, you can apply triggers at the database level.
--Jeff Moden
|
|
