February 25, 2010 at 10:27 pm
Every morning I see the file growth setting of one database changes from MB to %. I happens sometime during the day, and sure as hell it is not me. Is there anyway that I can see who changed or, or at what time it was changed?
Do you know of any script or trigger that can alert me when this happens?
Thanks in advance
February 25, 2010 at 10:35 pm
Which database is it (system or user)?
We had an issue with our tempdb doing the same thing. We fixed it by changing the model db settings.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2010 at 10:38 pm
It is a user database
February 25, 2010 at 10:40 pm
You might want to look into a ddl trigger at the database level or the use of event notifications. Either of these options could alert you to somebody trying to change the database properties.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 26, 2010 at 12:00 am
Hi,
The SQL Server Management Studio Standard Reports – Schema Changes History Report of the Respective DB can help you in identifying who changed this setting and when.
Cheers!!!
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
February 26, 2010 at 7:00 am
Search in default trace file for databasename='yourdbname' and eventclass=164 and objecttype=16964
February 26, 2010 at 9:20 pm
Thanks for the help
February 26, 2010 at 9:39 pm
Electrix (2/26/2010)
Thanks for the help
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply