SQL Server Performance Forum – Threads Archive

Error while updating table through view on 2 srvrs

I am facing the below error : "Unable to start a nested transaction for OLE DB provider ‘SQLOLEDB’. " While working through an application and connecting to the federated servers
(2 SQL servers) having the partitioned views and other updatable views used
to update data in tables on other SQL server. The error is encountered when I am updating a table on the other server through a view on this server with the same name as of table on that server.
I also suppose that the application uses cursors to update data in the tables of the database. Can we use "BEGIN DISTRIBUTED TRANSACTION" in view? If yes, how?
MSDTC is started on both the servers.
ANSI NULLS, ANSI WARNINGS, XACT_ABORT are ON the database.
Thanks in advance.
Techie

PLEASE DO NOT DUPLICATE YPUR POSTS!! —————————————-
http://spaces.msn.com/members/dineshasanka

I think you have posted this for the third time Madhivanan Failing to plan is Planning to fail

We understand the problem is really big at your end, but posting multiple (duplicate) posts will not get you quick answers. Rather it will create confusion for you to refer the various answers in different posts. Please adhere to the forum policies.[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] HTH <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

]]>