How to get Existing Service Borker GUID

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.

All Forums

SQL Server 2005 Forums

Service Broker (2005)

How to get Existing Service Borker GUID

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!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources