Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to find user who delete the data from table

Author  Topic 

ppaul4
Starting Member

1 Post

Posted - 2008-12-24 : 01:59:39
Dear All Hi,

I want to know is there any query or method or procedure through which I can find the user who delete the data from a particular table.

Or when (date and time) delete query was fired with details like (user name or machine)

Your help is appreciate

Prakash Paul

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-24 : 07:41:21
You need to use DML trigger or SQL Profiler or any third party tools to achieve this.
Go to Top of Page
   

- Advertisement -