March 20, 2006 at 1:55 am
Hi,
I need to be able to compare schema between tables. I would like this compare to run automatically and send notification when there is difference detected. Any one any ideas on the best way to do this?
Thanks
Kindest Regards,RJ
March 20, 2006 at 5:23 am
You can compare schema with sysobject & syscolumns tables.
But it can't be automated.
It can be done in SQLServer 2005. It has DDL Triggers.
R
March 21, 2006 at 6:44 am
You could have a scheduled job that stores the results for sysobjects and syscolumns and compares them daily. I've done this as a workaround before.
March 22, 2006 at 2:40 pm
Best bet in SQL 2000 or 7
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy