Showing posts with label queue. Show all posts
Showing posts with label queue. Show all posts

Friday, March 23, 2012

How many subscribers can Transactional replcation with queue update support ?

How many subscribers can Transactional replcation with queue update support
?
It is not really scalable with more than 10. Having said this I have seen it
deployed with 60 subscribers. It was not pretty. Stick with 10 or less.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Dennis JoJo" <denniswong@.shunhinggroup.com> wrote in message
news:uPEaYkD1EHA.824@.TK2MSFTNGP11.phx.gbl...
> How many subscribers can Transactional replcation with queue update
support
> ?
>

Friday, February 24, 2012

How I post a message on MSMQ?

Hi,
I want to execute a T-SQL for adding a message on a message queue, I know
that I can create a DTS task but I want to include it on a trigger. I found
extended procedures like xp_createprivatequeue and so on but no procedure to
push a message, Also I know that I can create my own xp to do it but I was
wondering if there is a simpler way,
thanks!
Salva
Salvador Alvarez Patuel
salvador.alvarez@.exony.com
Exony Ltd - London, UKHi
That is an undocumented XP and you should not use it.
SQL Server has no built-in methods to acces MSMQ. That belongs in a
middle-tier or your application.
Regards
Mike
"Salvador" wrote:

> Hi,
> I want to execute a T-SQL for adding a message on a message queue, I know
> that I can create a DTS task but I want to include it on a trigger. I foun
d
> extended procedures like xp_createprivatequeue and so on but no procedure
to
> push a message, Also I know that I can create my own xp to do it but I was
> wondering if there is a simpler way,
> thanks!
> Salva
> --
> Salvador Alvarez Patuel
> salvador.alvarez@.exony.com
> Exony Ltd - London, UK