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 |
|
hdv212
Posting Yak Master
140 Posts |
 Posted - 2009-04-07 : 04:54:27
|
| Hii want to monitor events. for example, what user working on which table, or list of users log (history of user operations).how to do that ?thanks |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-04-07 : 07:59:22
|
| Have a look at the Schema Changes History report - "provides a history of all committed DDL statetment executions within the Database recorded by the default trace."Or there are some SQL audit/compliance tools you can look at. |
 |
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2009-04-07 : 18:23:43
|
| Thanks but i need to detect DML statements on database, not DDL statements.for this, i designed a table named 'PersonHistory', then each user apply DML statements, a record insert to this tables to register user operation, but i think sql server has a built in feature which solve this issue. do you agree with me ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How to monitor events.