Trace Deleted Objects
-
Good Morning Everyone:
Is there any way to run a trace to show me who is deleting objects from a database, ie stored procs and tables? This is in a development environment so everyone has dbo rights, but someone recently has been deleting tables and stored procs, accidentally or purposefully, I don't know. It's getting time consuming re-building these objects and asking the developers not to delete anything didn't work. Any help is greatly appreciated.
Regards,
Donna Robbins
-
You can setup a trace, but you'd have to capture all T-SQL or stored proc executions on the server and dig through them.
-
Agreed totally with Steve.
Another thing to do is start playing with Sql Server 2005 and down the road convince your mgmt. for new product.
Sql 2005 has lot many new features, and one for your current requirement.
DDL Triggers so no one can drop required objects.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com -
Thanks for the replies. I am currently working on setting up a trace to track users who are deleting objects. As for 2005, we have one server already, but it is designated for a special project only. I still get to play with it, but it will be a while before they let me move the development environment to 2005. In the meantime, I'm stuck doing things the 'old fashioned' way!
Regards,
Donna Robbins
-
Donna,
There is a free software Lumigent Schema Alert, it will notify you if objects are dropped.
Jules Bui
IT Operations DBA
Backup and Restore Administrator
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply