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.

[Patrick D NOLAN]

Hello, I've used your SQLVer to keep track of changes in my application databases. It has been a life saver several times. Catching people lying about changes to SPs and what not has been very helpful. I've never used any of the performance tuning features you talk about and was wanting to get some documentation on that if you have anything available.

Thanks,

Patrick