Re: Last Saved/modified date of Stored Procedures

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 18:41:47 -0500

No there isn't. The only way currently to tell is if the sp was actually
dropped and recreated and then you could use the created date. Altering a
sp does not change this date. 

--
Andrew J. Kelly  SQL MVP
"J Baird" <jill[dot]baird[at]lmco[dot]com> wrote in message
news:eDjZlO$GEHA.3472@TK2MSFTNGP11.phx.gbl...
> I'm not sure if this is the right newsgroup for this, but I took a
guess...
>
> Is there any way to find the "Last Saved Date" or "Last Modified Date" for
a
> SQL Stored Procedure?  I have only found "Create Date" in SQL Enterprise
> Manager.
>
> Are Stored Procedures ever saved as files on the hard drive?  If they are,
> then maybe I could find the last saved date using Windows Explorer on the
> SQL Server.
>
> Any ideas for finding the Stored Procedure "Lst Saved Date", that don't
> involve installing any software (that's not an option in this case)?
>
>

Relevant Pages

  • Re: Views vs Stored Procedures, whats the difference?
    ... I hope you are not suggesting you embed SQL queries into the application? ... A stored procedure logic will be exactly as fast as the algorithm you ... I understant that SQL Server supports hints. ... implementations (nestedloop, merge, hash, ..) on decent sized tables, then ...
    (comp.databases.ms-sqlserver)
  • Re: Stored Procedures - Patterns and Practices
    ... >published the reasoning behind its opinions. ... I disagree that the debate in SQL Server related discussion forums ... If the natural key is long or spans too many ... I want to call a stored procedure that adds a customer ...
    (microsoft.public.sqlserver.programming)
  • Re: Issue with retrieving large data over web using Stored Procedu
    ... how do I go about analyzing a stored procedure with selecting ... Is there any tool in the SQL Profiler that analyze each Trace? ... "Active Server Pages error 'ASP 0113' ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.db)
  • Re: XML vs SQL Server
    ... The built in factory assumes a common syntax among the ... So as long as the sql can be shared, ... procedures for Sql Server and stored procedure for Oracle? ... Oracle supports stored procedure overloads, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: XML vs SQL Server
    ... Then, yes, the built in factory will be sufficient. ... So as long as the sql can be shared, ... procedures for Sql Server and stored procedure for Oracle? ... Oracle supports stored procedure overloads, ...
    (microsoft.public.dotnet.languages.csharp)
Loading