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 |
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
 Posted - 2009-01-18 : 23:37:40
|
| We have had cases of stored procs mysteriously disappearing. The last time it happened ~200 SPs were involved. Understandably, we are a little nervous.What are the options for auditing changes in this area so we can find out what is going on? Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-19 : 02:15:57
|
| one method is to record profiler traces to understand who is firing drop statements |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-19 : 06:38:47
|
| sql server 2008 has built in fast auditing capabilites. look into those.in SSMS Object explorer on server node -> Security -> auditsand then on the database you wish to audit -> Security -> database Audit specifications___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-01-28 : 02:41:50
|
| If default trace is enabled check it, you may get something. Use SQL Server 2008 databse Audit feature to prevent this from happening in future. |
|
|
|
|
|
|
Audit tracking SP changes on 2008