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)
 Log of SP Creation

Author  Topic 

mackenda
Starting Member

1 Post

Posted - 2009-03-23 : 08:12:45
Guys,

Is there a way to display the dates and times that a stored procedure was droped and created

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-03-23 : 09:53:10
there is only a create date for objects...unless you have some custom mechanism to track the creation/drop of objects.
you have more options (built in) in SQL 2008.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -