All Questions
2 questions
5
votes
2
answers
3k
views
Can't use msdb.dbo.sp_send_dbmail when in service broker - executes as guest?
I have a procedure TheNotificationProcedure that makes a cross-database call to msdb.dbo.sp_send_dbmail.
It gets invoked (indirectly) from a service broker queue:
CREATE QUEUE [Blah].[TheQueue]
WITH ...
- 151
5
votes
1
answer
745
views
SA permissions issues with many nested objects
I have a broker application that's relatively complicated.
Today, after I made some changes, I started getting the error:
The server principal 'sa' is not able to access the database 'XYZ' under ...
- 18k