SQL 2000 Linked Server Hangs Due To Trigger

[Brian Salentine]

Hi -
We have two SQL 2000 Servers. We have the linked server setup and we
can perform updates and inserts between the databases. But when we add
a trigger and insert something into a table, the database hangs. There
are NO processes blocking or being block in either database. This ONLY
occurs when we have one OS as Windows 2000 Server and the other OS as
Windows 2003 Server. This problem does not occur when both servers are
Windows 2000. Has anyone ran into anything similar to this???

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Simon Hayes]

One thing to check is the DTC service - it's disabled in Windows 2003
by default, and a trigger updating a linked server requires distributed
transaction support. Although it does seem a little strange that
there's no error message:

http://support.microsoft.com/default...b;en-us;831425
http://support.microsoft.com/default...b;en-us;329332

Simon

[Brian Salentine]

On Windows 2003, you have to do the following:

Go into Control Panel – Add/Remove Programs
Click on Add/Remove Windows Components
Click on Application Server and go into Details
Check “Enable network COM+ access”
Check “Enable network DTC access”

I do not have those checked.

Thanks all for the help!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!