Last Saved/modified date of Stored Procedures

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)?
HI,
SQL Server will not save the modied date and time of any objects (Tables,
Views, procedures, triggers...).
Thanks
Hari
MCDBA
"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)?
>
|||And in addition, no stored procedures aren't saved as files
on the hard drive - not unless you write scripts for the
stored procedures modifications and save those (which isn't
necessarily a bad idea). But SQL Server doesn't do anything
like that "behind the scenes".
If you want a new create date every time you modify a stored
procedure, you need to do a drop procedure and create
procedure instead of an alter procedure.
-Sue
On Tue, 6 Apr 2004 12:24:27 -0400, "J Baird"
<jill[dot]baird[at]lmco[dot]com> wrote:

>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)?
>
|||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)?
>