Hi,

I got stuck in the SQL Server 2005 security dependencies and can't find out.
Here's my problem:

I am using the service broker for running asynchronous stored procedures and
have created a queue with

CREATE QUEUE AsyncTargetQueue WITH STATUS = ON, RETENTION = OFF,
                             ACTIVATION(STATUS = ON ,
                                        PROCEDURE_NAME = sp_AsyncReceive,
                                        MAX_QUEUE_READERS = 1,
                                        EXECUTE AS OWNER)

This queue receives all messages and starts the stored procedure
sp_AsyncReceive which is owned by the dbo. The dbo has a login name who is
member of the sysadmin role (sysadmin is required for running the
xp_logevent procedure).

In the sp_AsyncReceive I am calling xp_logevent as user dbo with

EXEC xp_logevent 60000, @evtlogmsg, error

However, the call fails with the following error message in the event log:

'The EXECUTE permission was denied on the object 'xp_logevent', database
'mssqlsystemresource', schema 'sys'.'

Maybe somebody can give me a hint how to call 'sysadmin' functions under the
dbo user or how to change permissions for calling these functions in a
stored procedure which is started by a service broker queue.

Many thanks in advance,

Marcus