• Interests: Those that are of like precious faith, SQL Server

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,528 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,355 reads

Blogs

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Daily Coping 16 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to grant Exec ON multiple Stored Procedures

By ArnolddG

Hi, I have multiple Stored Procedures that are named like _Test_01, _Test_02 _Test_03 I...

XML data extract

By dbayliss1978

Hi I've been tasked with extracting information for a report where the field type...

There is insufficient sys memory in resource pool 'internal' to run this query

By WhiteLotus

Hi All, I have an issue with production server , from SQL error log...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers