msmq to sql?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,
If I'd like to ensure that in case sql server is down user still can
access and write the the data what option do I have? Since writing is more
important I thought about MSMQ tu put between the server and the
application, but what about reading? Any other techiniques?
In case of MSMQ, can you suggest any example how to use it with SQL server?
thanks


.

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)