how to identified PC who deleted table

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 identified PC who deleted table

Author

Topic

nisar
Starting Member

29 Posts

Posted - 2008-11-22 : 01:02:42

I want to know how you can identify pc name in sql server
like any user deleted one table i want to know from which
pc that table was deleted

table was already deleted one week ago

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-22 : 01:15:24

see your previous post

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=114981

nisar
Starting Member

29 Posts

Posted - 2008-11-22 : 02:19:21

Thanks,but this link does not have information what i m asking it says use third party tool like apex or set log from starting

anyway thanks for ur help

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-22 : 02:47:42

quote:
Originally posted by nisar

Thanks,but this link does not have information what i m asking it says use third party tool like apex or set log from starting

anyway thanks for ur help

it talks about a default trace if you're using sql 2005. did you have a look at it?

nisar
Starting Member

29 Posts

Posted - 2008-11-22 : 03:07:39

I m using Sql Server 2000

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-22 : 03:45:38