How can we help you today? How can we help you today?

MultiScript Changes Data on query

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.
padwin
0

Comments

6 comments

Sort by
  • 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
    0
  • Anu D
    I have dropped you an email with the solution.

    Kindly let us know if that fixed the issue.
    Anu D
    0
  • 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
    dlkj
    0
  • Solburn
    Has this issue been resolved yet???!!!
    Solburn
    0
  • 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
    James B
    0
  • Solburn
    Thanks James!!!

    The patch works great and I appreciate the quick response!
    Solburn
    0

Add comment

Please sign in to leave a comment.