We have a few tables on a database called
mydb which is being used by applications to store, or retrieve records. Somehow, someone changed a value on the
test table and that caused a serious issue.
We are receiving constant data from different sources, when the data is being updated on the table, a trigger fires and checks for the specific value, if the values is 360 then it will update the rows, else it will do nothing.
Now I have two questions:
- I want to know who changed that value 4 days ago?
- I dont see any successful login (user login) in the SQL server error log. I assume that someone has used a generic user account named
user. Now who used that account to login?
The value on the table is supposed to be 350, but it was changed to 800.