Single-click script execution on multiple SQL Servers.
Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor
I ran a simple script in Multiscript (version 22.214.171.124) to query the service broker GUID for a database. The script is as follows:
WHERE database_id = DB_ID()
(I presume that is: 2BE99620-A189-F646-8C08-C3285C869753)
When I ran the very same script in Query Analyser, it reported:
Does anybody know why Multiscript is reporting a different GUID from Query Analyser?
- Posts: 6
- Joined: Thu Sep 13, 2007 11:49 pm
- Location: Portland, OR USA
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.
- Posts: 151
- Joined: Tue Aug 14, 2007 5:10 pm
- Location: Red Gate Software, Cambridge
Return to SQL Multi Script 1
Who is online
Users browsing this forum: No registered users and 0 guests