Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Aug 25, 2000

Schema Version Control

By Tanya Stolyar

As a DBA you want to know when database schema has been changed: a table has been altered, a new table has been created or a table has been deleted

The usp_dba_schema_ver_cntrl stored procedure will send e-mail if these schema changes occurred. The best way to run it is through a scheduled job that will run regularly once every night. Please replace recipients string with the semicolon-separated list of the recipients of the mail.

This stored procedure checks the schema_ver and crdate columns in the system table sysobjects. According to the BOL, the schema_ver value gets incremented every time the schema for a table changes. The crdate column stores the date when a table been created. Checking the crdate value prevents anyone from dropping and recreating a table with the same name but different schema.

Download usp_dba_schema_ver_cntrl

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM