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 |
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
 Posted - 2008-03-12 : 06:03:40
|
| Hi All,Is there any option present in SSMS that ll audit all the changes(insert/update/delete) done to data in a database from SSMS( not through any application/front end).I dont want to place any trace or triggers, is there any in-built option. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-12 : 07:37:09
|
| Yes, With C2 Audit system but it hampers performance and consumes lots of space. |
 |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-03-12 : 09:04:34
|
| thanks for u r reply, butwith c2 Audit mode all the activities done through Front end also captured, i want only modifications done through SSMS/qury analyzer |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-12 : 09:27:52
|
| I would recommend Trigger for your case. You can use third-party tools for auditing as well. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-12 : 23:01:30
|
| >> i want only modifications done through SSMS/qury analyzerSet filter in profiler. |
|
|
|
|
|
|
Data Base Audit options