Obtain an MD5 Checksum per table of all the rows content for all tables in a database.

GetDataBaseMd5.sql

DECLARE @table_name NVARCHAR(255);
DECLARE @sql NVARCHAR(MAX);
DECLARE @sep NVARCHAR(10);
DECLARE @md5_hash NVARCHAR(32);

DECLARE table_cursor CURSOR FOR
SELECT name FROM sys.tables;

OPEN table_cursor;

FETCH NEXT FROM table_cursor INTO @table_name;
SET @sql = '';
SET @sep = '';
WHILE @@FETCH_STATUS = 0
BEGIN
    SET @sql = @sql + @sep + 'SELECT '''+@table_name+''' as TableName, HASHBYTES(''MD5'', (SELECT * FROM ' + @table_name + ' FOR XML AUTO)) as md5hash';
	SET @sep = ' UNION ';
    FETCH NEXT FROM table_cursor INTO @table_name;
END
CLOSE table_cursor;
DEALLOCATE table_cursor;

EXEC sp_executesql @sql, N'@md5_hash NVARCHAR(32) OUTPUT', @md5_hash OUTPUT;