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)
 LastUpdated date for a stored procedure in SQL 7.0

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-05 : 08:00:51
William Duvall writes "How do you determine what date/time a stored procedure was last updated, not created, but last changed or updated."

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-04-05 : 08:32:11
This one almost belongs in the FAQ.
You can't do it. The best way (and you should be doing this anyway), is do all your sproc development using script files which you keep in source control. That will track the history of changes in the file.

Damian
Go to Top of Page
   

- Advertisement -