Red Gate forums :: View topic - MultiScript Changes Data on query
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

MultiScript Changes Data on query

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
padwin



Joined: 04 Sep 2009
Posts: 3
Location: Texas, US

PostPosted: Fri Sep 04, 2009 2:41 pm    Post subject: MultiScript Changes Data on query Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 688
Location: Cambridge

PostPosted: Fri Sep 04, 2009 3:32 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Anu Deshpande



Joined: 20 Apr 2009
Posts: 688
Location: Cambridge

PostPosted: Fri Sep 04, 2009 3:51 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Mon Sep 07, 2009 9:44 am    Post subject: Reply with quote

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:
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
Back to top
View user's profile Send private message
Solburn



Joined: 25 May 2011
Posts: 2

PostPosted: Wed May 25, 2011 8:14 pm    Post subject: MultiScript Changes GUID Data on query Reply with quote

Has this issue been resolved yet???!!!
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Wed May 25, 2011 8:27 pm    Post subject: Reply with quote

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

ftp://support.red-gate.com/patches/SQL_Multi_Script/SQL_Multi_Script_1.2.0.28.zip
Back to top
View user's profile Send private message
Solburn



Joined: 25 May 2011
Posts: 2

PostPosted: Thu May 26, 2011 2:02 pm    Post subject: MultiScript Changes GUID Data on query Reply with quote

Thanks James!!!

The patch works great and I appreciate the quick response!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group