SELECT count(*) as CNT
FROM #table_name#
exec sp_columns @table_name = #table_name#;
(do some logic)
-----Original Message-----
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24, 2004 2:53 PM
To: CF-Talk
Subject: Compare 2 SQL Databases for structural changes?
Sorry, I forgot to include this in my other post.
I also need to know if anyone knows of any tools to compare 2 MS SQL
Databases for changes in structure. Ex: New tables, new fields, changes
in field types, etc. Thanks!
John
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
