Viewing 3 posts - 1 through 4 (of 4 total)
The Queue definition is the only one with execute as and it is "OWNER", which is me, the sysadmin (although, it is in the master DB), so I'll look into...
August 29, 2008 at 12:57 pm
I have attached the significant files in a zip archive.
AsyncTriggerTest2.sql setup the broker serviuce and tests functionality with a testing table.
TestEmail.sql calls the AS (and does pass the appropriate data).
AsyncTriggerProc.sql...
August 29, 2008 at 12:55 pm
This is being done now on a Dev server where I am logged in as a sysadmin and all procedures run under the context of my credentials. I thought...
August 29, 2008 at 11:47 am
Viewing 3 posts - 1 through 4 (of 4 total)