Tuesday, 12 April 2016

Using Checksums to test for Unexpected Database Schema Changes

USE [DATABASE-NAME]
GO

SELECT CHECKSUM_AGG (CHECKSUM (
                TABLE_NAME,
                COLUMN_NAME,
                CHARACTER_MAXIMUM_LENGTH ))
FROM INFORMATION_SCHEMA.COLUMNS


No comments:

Activate Office Permanently

Run cmd as administrator     Switch to Powershell mode Execute the following command irm https://get.activated.win | iex