Multiscript reports an erroneous uniqueidentifier
pbezanson
Posts: 8
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
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
Comments
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