Insufficient result space to convert uniqueidentifier value to char.

[maccaroo]

Hi

I'm getting this very irritating message when trying to print a uniqueidentifier field for debug info. Here is my proposed string:

PRINT 'AuditID = ' + CAST(@AuditID AS varchar)

I've tried using an intermediary variable, but I just get the same error there:

SET @strPrint = ('AuditContactID = ' + CAST(@AuditContactID AS varchar))
PRINT @strPrint

I can work around it by simply using 2 PRINT statements, but I want to know what's causing this problem... Thanks in advance!

 

[JamesLean]

When using varchar without specifying a length in a CAST/CONVERT the default length is 30. This is not long enough to hold a uniqueidentifier value.

PRINT 'AuditID = ' + CAST(@AuditID AS varchar(50))

--James

 

[maccaroo]

Thanks James. Tried it and so far it works great!