SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Stored Proc last updated
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

swatib
Posting Yak Master

India
173 Posts

Posted - 12/13/2005 :  06:57:21  Show Profile

Hello.........

Is there a way to find out when a stored procedure was last updated?

Njoy Life

madhivanan
Premature Yak Congratulator

India
22772 Posts

Posted - 12/13/2005 :  07:02:53  Show Profile  Send madhivanan a Yahoo! Message
No way until you run profiler and save the result or manually document it

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

swatib
Posting Yak Master

India
173 Posts

Posted - 12/13/2005 :  07:06:03  Show Profile
Hmmm.......... OK Boss

Njoy Life
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22772 Posts

Posted - 12/13/2005 :  07:10:39  Show Profile  Send madhivanan a Yahoo! Message
Are you preparing for interview?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

swatib
Posting Yak Master

India
173 Posts

Posted - 12/13/2005 :  07:13:44  Show Profile
No.... I'm trying to find the answers of the questions that can be raised 4 SQL Server.

Njoy Life
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 12/13/2005 :  08:21:40  Show Profile
"Is there a way to find out when a stored procedure was last updated?"

SQL stores the date the Sproc was created but not when it was updated

If you always use DROP PROCEDURE ... CREATE PROCEDURE ... you can use that date. However, if you use ALTER PROCEDURE ... you can't

We have an SProc call at the top of all our scripts that "logs" the fact that that script was run, and this allows us to see the dates when we ran a particular script (it also logs the "version number" of that script).

We store each Stored Procedure in a separate file, so in effect we get a LOG of whenever each Sproc is updated.

Kristen
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22772 Posts

Posted - 12/13/2005 :  08:28:28  Show Profile  Send madhivanan a Yahoo! Message
quote:
Originally posted by swatib

No.... I'm trying to find the answers of the questions that can be raised 4 SQL Server.

Njoy Life


Thats good
Regularly visit this site and read the threads

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000