Service Broker Queue Activation Defaults 1

[rebelknight]

When creating a service broker queue you can specify the procedure to run when a message is received on the queue with the ACTIVATION parameter list.

The default status is for it to be switched on.
What is the default context for the procedure to run?
You can specify EXECUTE AS but if you do not, is it run under the context of the Queue owner or the stored procedure owner ( assuming the stored procedure has not got EXECUTE AS included in the code ).

 

[mrdenny]

It doesn't appear to be documented anywhere in BOL. I would assume OWNER would be the default.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[rebelknight]

Yea thats what I guessed.