Another way to deal with the conversion issue is to exclude it since decimal values are not allowed in the solution. By using Modulo and excluding the invalid decimals the...

GP will not automatically switch to the backup server, it's not supported in the software. The technology used in GP doesn't have the intelligence to perform that function, the base...

Ahhh, the joy's of GP. :crying: This is NOT a normal SQL Server situation due to the way the application was written, it's extremely application specific.

Unless something drastic has...

I've had this happen before, when SQL was stopped to delete the log file you got as much of a commit as it possible, usually the log file has committed...

There is an undocumented function that will help

DECLARE @HashThis varchar(255);

SELECT @HashThis = 'Hello world!'

SELECT HashBytes('MD5', @HashThis)

SELECT SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @HashThis)), 3, 32)