FINDING UPDATE LOGS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

FINDING UPDATE LOGS

Author

Topic

lovinguy
Starting Member

12 Posts

Posted - 2009-07-09 : 15:21:20

Someone has updated the price table of my database.Is it possible to find out the machine name or IP address of the machine who has updated the prices of few products in the price table.Can someone can suggest me the tools or query to find out who made the changes.I am having MDF and LDF files also with me.

Thanks

Lovinguy

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-07-09 : 15:30:39

Not unless you had a trace running.

If you're in full recovery and haven't backed the log up, you may be able to read the tran log and get the session_id and user_id of the connection that did the update, but if that session has disconnected, the info on ip address and machine name is gone.

You can use the technique described here, with some modifications
http://www.sqlskills.com/BLOGS/PAUL/post/Finding-out-who-dropped-a-table-using-the-transaction-log.aspx

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources