July 10, 2003 at 9:01 am
Hi! I was wondering if I could tap into your knowledge base to try and resolve a problem that we've been having recently. It would appear that for some reason important tables are being dropped, then created again, but not being populated with data. I can't see any jobs that are currently running so what I would like to be able to do is to log all "DROP TABLE" events if possible. I know I could use SQL Profiler to do this but to be honest, what would be more advantageous is a SQL script or similar that is fired when specific tables are dropped. Is this possible? I have set up triggers for insert, update and delete within the table (called cms_data) but this doesn't inform me of a DROP command being issued. If this could write to another table with the details of the user and the table dropped this would be idea. Any ideas are much appreciated!
Thanks, James
July 10, 2003 at 9:09 am
Try Lumignet Schema Alter at http://www.lumigent.com/downloads/schemaalert/ and it is free.
July 10, 2003 at 9:27 am
Allen_Cui, thank you for this, it's exactly what I was after! What a great piece of software!
Thanks again for your help!
James
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply