MS-DTC / SQL Server 2000



There is apparently a new worm called "Dasher" that
is making the rounds:

http://www.computerworld.com/securitytopics/security/virus/story/0,10801,107144,00.html?source=NLT_AM&nid=107144

It apparently exploits a "recently patched" flaw in MS Distributed Transaction Coordinator.

Does MS SQL Server 2000 require MS DTC for anything besides
distributed update transactions, where "distributed" means
two or more database servers?  If a server doesn't participate
in such transactions, can I safely disable MS DTC on that box?
.



Relevant Pages

  • Re: DB design, facilitates Double entries of internal transactions
    ... The single server is also ... transactions, even if just a pair of ID's/amounts, is still double entry. ... but I would tend to recommend SQL Server ... Stored Procedures and transaction control on the server. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: COM+/DTC + firewall + SQL Server = need help
    ... Configuring Microsoft Distributed Transaction Coordinator (DTC) to ... Since you are only using one SQL Server, why are you using COM+ distributed ... If you have no need for a distributed transaction stop using transactions ...
    (microsoft.public.sqlserver.security)
  • Re: Transactions across batches
    ... Consider using the Server Defaults. ... set up default user connection environment settings. ... Set the ANSI compliant defaults: ANSI NULLS, ANSI WARNINGS, ANSI PADDING, ... Set CURSOR LOCAL, NOCOUNT ON, and IMPLICIT TRANSACTIONS ...
    (microsoft.public.sqlserver.server)
  • Re: Merge versus Two Way, Bidirectional Transactional Replication
    ... ranges are blown and transactions are kicked back and lost. ... Looking for a SQL Server replication book? ... You can restore a publisher or subscriber without ...
    (microsoft.public.sqlserver.replication)
  • Re: How to diagnose performance problems in web applications?
    ... >> where most of the delay for HTTP transactions is taking place. ... statistics at the time of the high demand would be a useful approach. ... was attempting to authenticate to the IMAP server with an incorrect ... which may indeed turn out to be poor design. ...
    (comp.unix.solaris)