Home

SQLVer is a T-SQL based solution for automatically tracking all DDL changes made to a MSSQL database. DDL stands for Data Definition Language, and refers to statements like CREATE TABLE, CREATE INDEX, ALTER TABLE, CREATE PROCEDURE, ALTER PROCEDURE, CREATE FUNCTION, DROP PROCEDURE and the like.

SQLVer will passively log all such changes to your database without any user intervention.

SQLVer can do a lot more too, including:

• listing changes
• retrieving old copies of objects
• supporting run-time logging (think debug and performance tuning logging)
• find a string in SQL source code anywhere in the database
• identify slow queries
• identify connections that are hogging resources and blocking object access

and more.

SQLVer is installed by running a single SQL script file. It is safe to install in both dev and production environments.

It will create a schema in your database named sqlver and will add all needed objects there.

It can be uninstalled with a single command.

[David Rueter]

Feel free to ask any questions about SQLVer. I have a lot more to say about it, and will add to this documentation wiki as I am able.

I have been using SQLVer extensively for years in demanding production environments. I don't think I could survive without it our something similar.