Bhuvnesh (11/12/2013)
Why the database needs to be set "trust worthy" in case of SB ?
Good question, I don't have a good answer to it. :w00t:
I mention this briefly in Part 2[/url].
You will get this error in sys.transmission_queue:
One or more messages could not be delivered to the local service targeted by this dialog.
It seems the db on which Service Broker is running needs to be trustworthy to be able to access objects on other databases through Service Broker.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]