What objects were created, altered and deleted in the past 24 hours?

Part of knowing your server(s) and part of monitoring is to know what changes happened to the environment recently. In this sense, it would be a good idea to look into the default trace daily in order to see what changed in the system. The following script will give you a list of all objects

Continue reading […] What objects were created, altered and deleted in the past 24 hours? […]

 

Changing the default trace settings

Recently I emailed a few great DBA stars with a question:

 

I have a question for you: do you know if there is a way to alter the properties of the default trace in SQL Server 2005 and 2008? More specifically, I am curious if we can change the number of rolled over files and their

Continue reading […] Changing the default trace settings […]

 

The default trace as an entry point for performance and security auditing

Starting with SQL Server 2005, there were a number of new tools provided in the product which would help the SQL Server administrator have vital information within close reach.

These tools (hm, I should probably not call them ‘tools’, since most of them were far from being finished tools with proper UI and easy access)  include:

the

Continue reading […] The default trace as an entry point for performance and security auditing […]