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 |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2010-09-16 : 11:30:49
|
| Where can I find the activity of user to the database? Such as when Administrator added a new table, when sa password was changed by somebody? The SQL Server Logs in Management just shows when backups happened, when a login got error. There is nothing showing the user’s activities. But, it got to be shown somewhere.Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-16 : 12:27:50
|
| some of this can be done with DDL triggers and traces, but to fully audit your database you need to look at 3rd party products like Lumigent AuditDB |
 |
|
|
lw1990
Yak Posting Veteran
85 Posts |
Posted - 2010-09-16 : 15:08:53
|
| Thanks Russell,Aren't those users activity information saved in system database and we can query them out? Is SQL Server Logs the only place to see the log of the database? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-16 : 15:12:01
|
| no they aren't stored anywhere. you can purchase a log reading tool, such as Apex SQL Log to get much of what you're looking for.again for constant auditing, you'll want an auditing tool though. |
|
|
|
|
|
|
How to find user's activity records