[Broker] Internal Activator

in Sql Service Broker (fin dal sql 2005) è possibile abilitare una coda in modo che attivi in automatico una stored procedure nel momento in cui riceve un messaggio:

ALTER QUEUE queueName
WITH ACTIVATION
( STATUS = ON, PROCEDURE_NAME = spName,
MAX_QUEUE_READERS = 10,
EXECUTE AS SELF
); GO
dove il parametro MAX_QUEUE_READERS che specifica il numero massimo di istanze della sp da eseguire

posted @ mercoledì 18 gennaio 2012 11:34

Print

Comments on this entry:

# financial planning

Left by financial planning at 27/01/2012 14:00
Gravatar
Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!

# re: [Broker] Internal Activator

Left by shox sko at 11/02/2012 07:20
Gravatar
like nike sko very much and Nike Free Run every years , iam nike brand fans ,
i have a lot of Puma sko dame in my room

# coolbot

Left by coolbot at 13/02/2012 10:56
Gravatar
I agree with most of your points, but a few need to be discussed further, I will hold a small talk with my partners and maybe I will look for you some suggestion soon.

# website creation

Left by website creation at 24/02/2012 08:58
Gravatar
I’ve research a few amazing products here. Surely bookmarking for revisiting. I ask yourself how much perform you set to create such a amazing useful web page.

# re: [Broker] Internal Activator

Left by meizitang at 25/02/2012 12:08
Gravatar
cool site

# re: [Broker] Internal Activator

Left by value of annuity at 17/03/2012 19:12
Gravatar
This is valuable information for me. Thanks a lot for sharing about this.

# re: [Broker] Internal Activator

Left by pneumatic conveyors at 30/05/2012 18:10
Gravatar
great information. Manufacturer of conveyors in delhi

# re: [Broker] Internal Activator

Left by jaffa at 27/06/2012 15:51
Gravatar
Great.
Comments have been closed on this topic.
«ottobre»
domlunmarmergiovensab
262728293012
3456789
10111213141516
17181920212223
24252627282930
31123456