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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-12-09 : 01:02:12
|
| Dear All,i'm using sql server 2005 on windows server 2003 environment. we are using transactional replication. How can i trace the users that which user from which database doing nonsense? how can we trace users? we need to run the profiler continuously? or is there any way to find?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
Jason100
Starting Member
34 Posts |
Posted - 2008-12-09 : 02:25:50
|
| you can have a try sp_who2 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-09 : 02:46:07
|
| sp_who2 lists only processes running by various users. to get query details you need to take processid and use dbcc inputbuffer(processid) |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-09 : 05:08:01
|
| processID means spID?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
how to know which user did wrong