MultiScript Changes Data on query

padwin

Hello all, I have a support ticket open with Red Gate and it doesnt seem to be going anywhere. My problem is that I'm querying 65 SQL servers to get data into a file to import to another server. So upon collecting the data I notice that the UniqueIdentifier field data has been modified from its original format. In Sql Mgmt studio it displays it correctly but in mutliscript it mods it. Has anyone come across this same issue? any help is greatly appreciated.

Anu D

As per our telephonic conversation we are looking into this issue and I will get back to you on this.

Many thnaks for your patience.

Anu D

I have dropped you an email with the solution.

Kindly let us know if that fixed the issue.

dlkj

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:

DECLARE @guid UNIQUEIDENTIFIER ;
SET @guid = NEWID() ;
SELECT  CONVERT(NVARCHAR(100), @guid) AS 'NVARVCHAR',
        @guid AS 'UNIQUEIDENTIFIER',
        CONVERT(BINARY, @guid) AS 'BINARY' ;
GO

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.
--
Daniel

Solburn

Has this issue been resolved yet???!!!

James B

The repro steps don't exhibit the problem in this patch build:

ftp://support.red-gate.com/patches/SQL_ ... 2.0.28.zip

Solburn

Thanks James!!!

The patch works great and I appreciate the quick response!