Red Gate forums :: View topic - Multiscript reports an erroneous uniqueidentifier
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 reports an erroneous uniqueidentifier

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



Joined: 13 Sep 2007
Posts: 6
Location: Portland, OR USA

PostPosted: Wed Dec 10, 2008 9:15 pm    Post subject: Multiscript reports an erroneous uniqueidentifier Reply with quote

I ran a simple script in Multiscript (version 1.1.0.34) to query the service broker GUID for a database. The script is as follows:

use iAlert

SELECT service_broker_guid
FROM sys.databases
WHERE database_id = DB_ID()

It reported:
0x2BE99620A189F6468C08C3285C869753
(I presume that is: 2BE99620-A189-F646-8C08-C3285C869753)

When I ran the very same script in Query Analyser, it reported:
2096E92B-89A1-46F6-8C08-C3285C869753

Does anybody know why Multiscript is reporting a different GUID from Query Analyser?

TIA

Paul
Back to top
View user's profile Send private message
dlkj



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

PostPosted: Mon Dec 15, 2008 11:59 am    Post subject: Reply with quote

Hi Paul,

the value SQL Multi Script is showing is the raw binary representation of the GUID. They are equivalent, but due to a difference in byte ordering, they look different.

I've logged this as a display issue.

Cheers,
--
Daniel
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