An update was made on a table in database BAC. I know the approx time this happened.
I need to find out from which machine this query was made.
The issue is we all use the same userid/password to log in. So the SSID does not help.
I looked into the transaction logs but was not successful. I do have sa privileges.
WHERE [Operation] = 'LOP_BEGIN_XACT'
AND [Begin Time] >= '2014/05/07 05:35:23:053'
AND [Begin Time] <= '2014/05/07 06:35:23:053'