MultiScript Changes Data on query

padwin · September 4, 2009 9:41AM

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 · September 4, 2009 10:32AM

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 · September 4, 2009 10:51AM

I have dropped you an email with the solution.

Kindly let us know if that fixed the issue.

dlkj · September 7, 2009 4:44AM

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&#40;&#41; ;
SELECT  CONVERT&#40;NVARCHAR&#40;100&#41;, @guid&#41; AS 'NVARVCHAR',
        @guid AS 'UNIQUEIDENTIFIER',
        CONVERT&#40;BINARY, @guid&#41; 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 · May 25, 2011 3:14PM

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

James B · May 25, 2011 3:27PM

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

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

Solburn · May 26, 2011 9:02AM

Thanks James!!!

The patch works great and I appreciate the quick response!

MultiScript Changes Data on query

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk