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_guidFROM sys.databasesWHERE 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 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
|
|
|
How to get Existing Service Borker GUID