how to find out the who last modfied the stored procedure

Hi ,
I want to know how to find out the who last modified any stored procedure
in the database.
is there any way?
thanks in advance
BhaskarHi,
No, SQL Server will not store the modified date and time. Only object
created date and time is available in sysobjects table.
Thanks
Hari
SQL Server MVP
"Bhaskar" <Bhaskar@.discussions.microsoft.com> wrote in message
news:1245248B-05D4-402A-A828-1636FCDCA8C4@.microsoft.com...
> Hi ,
> I want to know how to find out the who last modified any stored procedure
> in the database.
> is there any way?
> thanks in advance
> Bhaskar
>|||SQL Server does not save that info in the system tables. May be using a thid
party software that can read the log.
New features in Log Explorer 4.0
http://www.lumigent.com/products/le...ewfeatures.html
AMB
"Bhaskar" wrote:

> Hi ,
> I want to know how to find out the who last modified any stored procedure
> in the database.
> is there any way?
> thanks in advance
> Bhaskar
>|||Ok. Thanks for your replies.
Bhaskar
"Alejandro Mesa" wrote:
> SQL Server does not save that info in the system tables. May be using a th
id
> party software that can read the log.
> New features in Log Explorer 4.0
> http://www.lumigent.com/products/le...ewfeatures.html
>
> AMB
> "Bhaskar" wrote:
>