470,586 Members | 1,368 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

SQL 2000 Linked Server Hangs Due To Trigger

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!
Jul 23 '05 #1
2 1780
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

Jul 23 '05 #2
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!
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by simonfunston | last post: by
3 posts views Thread by Senthuran | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.