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

Popular posts from this blog

Generate Password

Key Board Shortcuts