Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I created a stored procedure which queries data from a linked server to insert into a local table.

I tested this stored procedure by directly executing it; it works fine.

I have to run this stored procedure every day, so I created a job to handle it.

But when the job run, it throws an exception:

Error Number: 7391
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "{server name}" was unable to begin a distributed transaction.

share
2  
Anything in the Windows Application Events event log? What happens if you set the Enable Promotion of Distributed Transactions property of the Linked Server to False ? –  Andomar May 22 '13 at 5:21
    
If you are using transaction in your SP please enable distributed transaction. Or change your SP so that your queries which refers to the linked server will be outside the transaction. –  Sivakumar May 22 '13 at 5:28
comments disabled on deleted / locked posts

migration rejected from stackoverflow.com Sep 28 '13 at 12:45

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Max Vernon, Paul White, Kin, Mark Storey-Smith, bluefeet Sep 28 '13 at 12:45

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.