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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-25 : 08:12:09
|
| Tom Keith writes "All,Is there a way in sql server to find out and notify if a object has been modifed. i.e - A table structure has been modified or dropped - A truncate has been issued on a table - A view got changed or dropped - A stored procedure got changed or dropped - A index got changed or dropped - A constraint got changed or droppedThe reason I am asking is that if there is a no change control and no body is aware of it and a change happens, then I would like to capture who did that?Any answers would be helpful.- Tom" |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-25 : 08:35:56
|
| You need to address the issue, not report it. Lock down the permissions on your databases so that only known people can drop or change objects. Elsewise, auditing like this is not inbuilt.-------Moo. :) |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-25 : 21:14:09
|
| You can perform certain auditing functions using SQL Profiler, which is documented in Books Online. Otherwise, you'll have to purchase a third-party auditing tool like Entegra:http://www.lumigent.com/But as Moo suggests, an ounce of prevention is worth a pound of cure. Lock down your user's logins and make sure NO ONE, not even you, are using the SA login. |
|
|
|
|
|
|
How to notify when a Object has been modified or deleted?