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
BJ
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