June 13, 2007 at 2:41 am
Hello everybody,
I need a help where in i need to find the user/machine who had altered the stored procedures/functions. Since the objects are altered, they are not registered in the Enterprise manager(SQL 2000). I have come across articles where it was mentioned that we can trace it out by executing a query in the MASTER table. Can anybody let me know the query to find the required result.
With Regards,
Sudarsan S
June 13, 2007 at 2:46 am
I am not sure if any object already altered can be traced. You can trace current activity in the server using sysprocesses table and manipulating against it. but if someone has altered a procedure a week ago i don't think so it is possible.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 13, 2007 at 2:58 am
Lets say, it was altered either that very day or the previous day. cant we find anything from the logs??
June 13, 2007 at 6:28 am
no way unless you have auditing aenabled and use a profiler to find that data.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 13, 2007 at 6:50 am
You can do this using products such as Lumigent's Log Explorer if you stil have the transaction logs for when the sproc was changed. There are other similar products out there so if you decide that Log Explorer is not for you, there are options.
Trial copies can be downloaded from http://www.lumigent.com. There is a bit of user registration required so you can expect some followup emails.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply