| Author |
Message |
padwin
Joined: 04 Sep 2009
Posts: 3
Location: Texas, US
|
 Posted: Fri Sep 04, 2009 2:41 pm Post subject: 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 |
|
| Back to top |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 595
Location: Cambridge
|
| Posted: Fri Sep 04, 2009 3:32 pm Post subject: |
|
|
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 |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 595
Location: Cambridge
|
| Posted: Fri Sep 04, 2009 3:51 pm Post subject: |
|
|
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 |
|
|
dlkj
Joined: 14 Aug 2007
Posts: 150
Location: Red Gate Software, Cambridge
|
| Posted: Mon Sep 07, 2009 9:44 am Post subject: |
|
|
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 |
|
|
Solburn
Joined: 25 May 2011
Posts: 2
|
| Posted: Wed May 25, 2011 8:14 pm Post subject: MultiScript Changes GUID Data on query |
|
|
| Has this issue been resolved yet???!!! |
|
| Back to top |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 864
Location: My desk.
|
|
| Back to top |
|
|
Solburn
Joined: 25 May 2011
Posts: 2
|
| Posted: Thu May 26, 2011 2:02 pm Post subject: MultiScript Changes GUID Data on query |
|
|
Thanks James!!!
The patch works great and I appreciate the quick response! |
|
| Back to top |
|
|
|
