"OLE DB provider 'SQLOLEDB' distributed transaction" ERROR

[JulesDBQ]

Hello,

I included this error on an existing thread of mine regarding linked servers. Since the linking of the servers has been resolved, I was unsure if anyone took a peek at my second question?

Now that I have successfully linked the remote server to my SQL server, I can run queries to view the data. I am having problems saving my queries, views, stored procedures, etc. When I try to save my SQL code, I get an error that says..."OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction....etc...etc"

I have done searches on this forum and found others who have run into this error. Due to the fact that I have NO control over DTS or anything on the linked server, is there anything I can do to get past this error?

Any assistance or advice you may have would be appreciated. Thanks again for all of you help!!

 

[SQLDenis]

Is DTC running?

do you have SET XACT_ABORT On in your procs

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[JulesDBQ]

This may sound like a stupid question....but...

How do I know if DTC is running?

What if it is running on my server, but not on the remote server that I am linking to?

Thanks!

 

[SQLDenis]

From service manager check if DTC is running or you can also check from Services (admin tools/services)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[mrdenny]

In order to perform a distributed transaction DTC must be running on both servers.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JulesDBQ]

Thanks to everyone....I will check to see if DTS is running on both of the servers involved.