Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-08-26 : 07:03:23
|
Hi,
Could I know how I can get existing service broker GUID?
Thanks,
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-08-26 : 07:05:28
|
It can be done by running this:
SELECT service_broker_guid
FROM sys.databases
WHERE name = 'DBName' |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-26 : 07:27:59
|
oh and you can also use 'current database' instead of the SB guid. this of course only works if you're accessing SB in your current database 
_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
|
|
|
How to get Existing Service Borker GUID