Get a User that has Deleted Rows with SQL July 27, 2017 Getting a user that has deleted rows with SQL is a multi-part process. First you have to search the transaction log file for information on deleted rows. SELECT [Transaction ID],