Re: Who is using MSMQ?



SQL Server does not use MSMQ except in some rare replication scenarios.
MSMQ does use MSDTC however which is why you get the error when you shut
down MSDTC. MSDTC is used by SQL Server but it is actually part of Windows.

SQL Server 2000 is version 8.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Sam Hobbs" <samuel@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OBOHImQLGHA.2812@xxxxxxxxxxxxxxxxxxxxxxx
Who is using MSMQ in my XP Pro system? I have SQL Server but I use it only
for development purposes. I think it is SQL Server 2000 but the EM About
box says version 8.

When I use SQL Server Service Manager to shutdown SQL Server, DTC is
running too. When I try to shut that down, I get a warning that MSMQ and
MSMQTriggers depend on it. Is this normal? I assume so, but I would feel
better if I knew for sure. One thing that I don't like about Microsoft
software is that it often does things automatically without us having a
way to know what is happening. Are MSMQ and MSMQTriggers installed with
SQL Server? I assume so.




.



Relevant Pages

  • Re: Who is using MSMQ?
    ... SQL Server is one of several services ... that sometime uses DTC to manage distributed transactions. ... to shut down DTC for whatever reason, the dependency logic listed MSMQ as ... Do you know why the SQL Server Service Manager is asking ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... MSMQ is not installed with SQL ... But as Roger pointed out this is not dependant on SQL Server ... the MSDTC service it can affect other services that depend on MSDTC, ... When I use SQL Server Service Manager to shutdown SQL Server, ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... SQL Server?" ... and the answer here is that "MSDTC is used by SQL Server but it ... The extent to which SQL Server uses MSMQ is ... MSMQTriggers depend on it. ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... To add on to the other responses, the MSMQ warning messages you get from the ... SQL Server Service Manager are the same ones you get from the Windows MMC ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... it is normal to get the qustion asking about MSMQ and MSMQTriggers. ... Do you know why the SQL Server Service Manager is asking ...
    (microsoft.public.sqlserver.security)