March 7, 2011 at 6:19 am
Hi all
I am new to Service Broker but I'm trying to use it to run a stored procedure as a background process as it may take many hours to complete.
I used the example provided by Remus Rusanu at http://rusanu.com/2009/08/05/asynchronous-procedure-execution/, which is excellent and kicks off a stored proc just fine.
The stored proc runs fine when called from SSMS but fails when I try to run it under SB. I can run other, simple sprocs using SB, so that part is working. What appears to be the problem is that SB is running in a different security mode than my user, which has the necessary permissions (ie BULKADMIN).
I am no SQL Server guru, so I don't understand why, when CURRENT_USER is dbo, when I do "execute as user='dbo'" and check "is_srvrolemember ('bulkadmin')" it returns false. But I guess this is something to do with my problem.
Is the problem solveable, or do I have to work out another way of getting background imports to run?:(
Hope you can help,
John
March 7, 2011 at 10:19 am
Can you give us the specific command or statement that Service Broker is choking on, and any exact errors you may have encountered?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply