SQL Server - Query to know who deleted and when deleted rows from Table.

Asked By Lalitha Kumaran on 08-Dec-12 04:03 AM
In My Master Table, I have added 3 rows a week back.Someone has deleted 2 rows.Now, I wanted to know who deleted and when deleted data from table.

Kindly help me to get the details

Very very important andurgent
Robbe Morris replied to Lalitha Kumaran on 08-Dec-12 11:25 AM
Unless you previously set up SQL Server auditing or wrote your own code, you are outta luck.

Depending on your logging configuration, you might be able to get a SQL Server Log Reader and find it.  Of course, knowing "who" did it would require that each of your users use a specific windows/sql account.