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

Technical Article

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,529 reads

Technical Article

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,360 reads

Blogs

Daily Coping 26 Jan 2023

By

Today’s coping tip is to focus on what’s good, even if today feels tough....

Working With Tags in FlashArray using PowerShell

By

Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...

Using SQL Data Compare from the Command Line with a Project

By

SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Read the latest Blogs

Forums

Visual Studio Code - SQL Server (mssql) Version 1.17.0 - Encryption By Default

By o.schoen

Microsoft is warning of a "BREAKING CHANGE" and indeed this little update took my...

SQL Table Issue

By Jobs90312

Hi everyone, In below code I am creating a table and inserting some english...

what does the backup log init do?

By vpmaciel

what does the backup log init do?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers