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.
| Author |
Topic |
|
rohitvishwakarma
Posting Yak Master
232 Posts |
 Posted - 2011-04-26 : 04:27:39
|
| I have got one table updated with some wrong values. Its for sure that the rows have been updated 2 days back. How to know which user executed the update statement on that table?I am using SQL SERVER 2008.Thanks in advance. |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2011-04-26 : 05:24:37
|
| For that you should have update trigger to maintain the log else its not possible to find out in SQL Server.Vaibhav TIf I cant go back, I want to go fast... |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-26 : 07:02:44
|
| Unless you had a trace or trigger at the time the update was done, you can't tell.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
How to determine who executed the query