MultiScript Changes Data on query

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

MultiScript Changes Data on query

Postby padwin » Fri Sep 04, 2009 2:41 pm

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
padwin
 
Posts: 3
Joined: Fri Sep 04, 2009 2:38 pm
Location: Texas, US

Postby Anu Deshpande » Fri Sep 04, 2009 3:32 pm

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.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Anu Deshpande » Fri Sep 04, 2009 3:51 pm

I have dropped you an email with the solution.

Kindly let us know if that fixed the issue.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby dlkj » Mon Sep 07, 2009 9:44 am

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' ;
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
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge

MultiScript Changes GUID Data on query

Postby Solburn » Wed May 25, 2011 8:14 pm

Has this issue been resolved yet???!!!
Solburn
 
Posts: 2
Joined: Wed May 25, 2011 8:11 pm

Postby james.billings » Wed May 25, 2011 8:27 pm

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

ftp://support.red-gate.com/patches/SQL_ ... 2.0.28.zip
james.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

MultiScript Changes GUID Data on query

Postby Solburn » Thu May 26, 2011 2:02 pm

Thanks James!!!

The patch works great and I appreciate the quick response!
Solburn
 
Posts: 2
Joined: Wed May 25, 2011 8:11 pm


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests