Who Deleted and Drop the record in table
CREATE DATABASE ReadingDBLog;
GO
-- Create tables.
USE ReadingDBLog;
GO
CREATE TABLE [Location] (
[Sr.No] INT IDENTITY,
[Date] DATETIME DEFAULT GETDATE (),
[City] CHAR (25) DEFAULT 'Bangalore');
select * from [Location]
INSERT INTO Location DEFAULT VALUES ;
GO 100
DELETE Location WHERE [Sr.No]=10
GO
SELECT * FROM Location WHERE [Sr.No]=10
GO
SELECT
[Transaction ID],
Operation,
Context,
AllocUnitName
FROM
fn_dblog(NULL, NULL)
WHERE
Operation = 'LOP_DELETE_ROWS'
SELECT
Operation,
[Transaction ID],
[Begin Time],
[Transaction Name],
[Transaction SID]
FROM
fn_dblog(NULL, NULL)
WHERE
[Transaction ID] = '0000:000002ef'
AND
[Operation] = 'LOP_BEGIN_XACT'
USE MASTER
GO
SELECT SUSER_SNAME(0x0105000000000005150000000C01DAF19D99C75199E0F64070040000)
USE ReadingDBLog
GO
DROP TABLE Location
USE ReadingDBLog
GO
SELECT
Operation,
[Transaction Id],
[Transaction SID],
[Transaction Name],
[Begin Time],
[SPID],
Description
FROM fn_dblog (NULL, NULL)
WHERE [Transaction Name] = 'DROPOBJ'
GO
SELECT SUSER_SNAME(0x0105000000000005150000000C01DAF19D99C75199E0F64070040000)
Comments
Post a Comment