Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Comparing objects

Author  Topic 

nikke
Starting Member

7 Posts

Posted - 2003-11-21 : 04:19:13
Hi,

My new challenge is to make a program that examines a database to see if any object has been changed from a date, alternatively has been changed compared to antoher database. The result should be a SQL script to generate the changed object, for example

"ALTER TABLE ADD COLUMN xxx..."
"CREATE TABLE yyy..."

My question: Is there any suitable Stored Procedures that returns the date the object last was changed.

Thanks in advance
/Nicke

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-11-21 : 07:51:10
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30680
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30557
Go to Top of Page
   

- Advertisement -