• 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,519 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,351 reads

Blogs

Using Write-Debug

By

I wrote a post about PoSh output recently, noting that in general we ought...

T-SQL Tuesday Retrospective #002: A Puzzling Situation

By

For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...

Daily Coping 28 Oct 2020

By

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

Read the latest Blogs

Forums

Funny code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Funny code

Building Quality In

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Quality In

Setting Rows to Odd and Even Values

By bkubicek

Comments posted to this topic are about the item Setting Rows to Odd and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Funny code

See possible answers