How to find userid of created or altered stored procedure in sql server 2005

Question

Hi friends
I need to find who altered the particular stored procedure finally in sql server 2005. i can get the last modified datetime from sys.objects table but i need to find userid. kindly let me know.

Thanks in advance for your help

Amit Choudhary · Answer

I've never heard of tables for traces.. but sqlserver maintains the log files.. that we can't read directly so u need a tool to read them...

Rajesh S · Answer

thanks for your good information....

Suthish Nair · Answer

refer msdn forum

Rajesh S · Answer

Hi Amit Is any system tables available to trace out..

Amit Choudhary · Answer

Hi friend See below article to audit the logs for sqlserver 2005 udpations or use the Sqlserver log reader software available on the internet. Thanks.