October 15, 2002 at 9:47 am
Is there a function, table, or script I can write that will notify if any updates are made to a database, table, stored procedure, etc.
Reason being, I want to know when these things occur so I know to generate new scripts to keep on file, incase a disaster ever occurs.
Also, is there a way to create script that actually generates sql scripts. I see you can use SQL-DMO, but is there another way?
Thanks
October 15, 2002 at 10:18 am
You could build a query to generate a script for a table. Check the script library here (Resource | Scripts).
There isn't a way to be informed of all changes. You can make frequent transaction log backups which will catch this. Lumigent also has released a free Schema Manager tool, not sure how it works.
Steve Jones
October 15, 2002 at 5:10 pm
Or run profiler and save the results for later analisys
October 16, 2002 at 4:41 am
Lumigent has a new freeware tool that will do it - by monitoring the log.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply