March 19, 2008 at 2:45 pm
Hi Everyone,
Is there any way to monitor DDL commands?
In our development environment we have several developers. I would like to follow-up changes on databases and tables.
Thanks,
March 19, 2008 at 2:51 pm
Yes, DDL triggers. One method would be to create a table to insert the information you wish to gather about the execution of a ddl statement, create ddl triggers (see Books Online, search for "ddl triggers") on each database so that the trigger inserts a record into this new table whenever a ddl statement is executed.
March 19, 2008 at 2:55 pm
Are DDL triggers available in SQL 2000?
March 19, 2008 at 3:13 pm
Nope, not available in 2000. Must be time to upgrade 😉 I never had a need to do this in 2000, so I'm not certian what your options are. However I did have a free tool from http://www.lumigent.com which seemed to work well. I'm not sure if they still offer it or not. It uses smtp to send email notifications whenever a ddl statement or any of a number of other events occur. It was a pretty simple and slick tool, best of all free....
March 19, 2008 at 3:33 pm
Well, I did some checking on that tool. Looks like I mislead you. It was part of another install of their log explorer tool, which is of course not free. So I'm afraid I can't help you without doing some additional research on the subject. ...but if you're looking for excuses to migrate to SQL 2005 or 2008..... 😀
March 19, 2008 at 4:20 pm
Thank you very much John!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply