Monitor Object Changes

Based on post http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=4349 I decided to write this script which will check for object changes in all databases and send an email listing the objects changed to the Operator associated with the job. This by no means offsets the need to restrict change access to objects in production, but in those cases when you […]

2002-05-23

1,515 reads

Monitor File Growth - Set Based sp_MSforeachdb

This is a script, similar to some you have seen in the past, that will monitor file growth on all databases for the given server. This script is not a fancy solution that has a tons of bells and whistles but, it is efficient. The script is a concantanation of the create table / populate […]

4.5 (2)

2001-12-21

3,345 reads

Blogs

How I passed the 70-761 certification exam

By

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Read the latest Blogs

Forums

What Write Ahead Logging Is and Why It Matters

By Kendra Little

Comments posted to this topic are about the item What Write Ahead Logging Is...

SSAS Error: Duplicate attribute key found when processing

By aveek22

Comments posted to this topic are about the item SSAS Error: Duplicate attribute key...

Using Calendars and Dates in Power BI

By Additional Articles

Comments posted to this topic are about the item Using Calendars and Dates in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers