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 Administration (2000)
 Last Updated datetime of An Object

Author  Topic 

Kaleem021
Starting Member

26 Posts

Posted - 2005-04-01 : 01:20:15
Dear All
How can I know the last udpdated datetime of an object(Table, View, Stored Procedure etc.). Actually I modify database schema at my end and want to update production database with the objects that I modified at my end.

I got this link [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=4513[/url] but find no clue.

Thanks in advance

Doing Nothing Is Very Hard To Do, You Never Know When You Are Finished.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-04-01 : 02:12:15
You can not do this currently.
Your best option is to keep your objects as scripts inside source control and use that to manage your releases.


Damian
Ita erat quando hic adveni.
Go to Top of Page
   

- Advertisement -