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-11 : 00:35:01
|
| Dear All,i've some doubts. please let me know regarding these, and supported linkes will be appreciated.1)running the sql profiler trace on client machine (connecting to the production) is suggestable? i mean i need to trace all the activities running on production. mainly i'd like to trace which user firing which query....2) is it possible to get an alert when any user fired a select or insert or update query through SSMS ro query analyzer?please clarify me in these aspectsArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-11 : 08:57:56
|
| you can use DML triggers for DML operation. You need to trace with profiler for select operation. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-16 : 00:10:10
|
| can you provide me a good document on how can i put DML triggers?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 00:13:11
|
| seems like what you need is event notification rather than DML triggers if you want to trace what user did what as well |
|
|
|
|
|
|
user Auditing doubts