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
Loading
Amit ChoudharyPosted Mar 9, 2011, 12:39 PM
Rajesh SPosted Mar 17, 2011, 6:54 AM
Suthish NairPosted Mar 10, 2011, 1:49 PM
Rajesh SPosted Mar 9, 2011, 9:54 AM
Is any system tables available to trace out..
Amit ChoudharyPosted Mar 9, 2011, 8:02 AM
See below article to audit the logs for sqlserver 2005 udpations
or use the Sqlserver log reader software available on the internet.
Thanks.