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.
| Author |
Topic |
|
nisar
Starting Member
29 Posts |
 Posted - 2008-11-21 : 23:45:29
|
| if any users deleted or create any table on sql server database how u can identified his login or his pc name |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-21 : 23:52:14
|
| One way to do this is to create DDL triggers on table and log the details to log table. Alternatively you can use SQL profiler to identoify person who deleted or created the table |
 |
|
|
nisar
Starting Member
29 Posts |
Posted - 2008-11-21 : 23:55:02
|
| you can do this only after when u want to know but i want to know if someone already deleted table and i dont have trigger or any think like that in that case how i will identify his pc name from which that sql statement was executed |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-22 : 01:14:27
|
| http://www.sqlservercentral.com/Forums/Topic423337-6-1.aspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-22 : 08:59:31
|
| Then you shouldn't let him create/drop table by restricting permission. |
|
|
|
|
|
|
how to identified user login information