Hi padwin, what you were seeing was a formatting error.
Multiscript was incorrectly returning the binary representation of the guid rather than the standard string representation.
The following script should demonstrate the issue:
- Code: Select all
DECLARE @guid UNIQUEIDENTIFIER ;
SET @guid = NEWID() ;
SELECT CONVERT(NVARCHAR(100), @guid) AS 'NVARVCHAR',
@guid AS 'UNIQUEIDENTIFIER',
CONVERT(BINARY, @guid) AS 'BINARY' ;
Red Gate support should have been in contact with you and can provide you with a development build of Multi Script that has a fix for this issue.
Let me know if you have any further issues with this.