THIS IS JUST AN EXAMPLE
Step 1. I have a registered linked server that is pointing to the local server (itselft) in the Client Network utility. It's alias is ALIAS.
Step 2. I create a view in pubs database
CREATE VIEW linked_server_view AS
SELECT * FROM ALIAS.master.dbo.sysobjects
Step 3. The following statement will return a SQLOLEDB Provider error:
SELECT * FROM ALIAS.pubs.dbo.linked_server_view
ERROR:The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
If anyone has a solution or a workaround, I'd be grateful!!
Step 1. I have a registered linked server that is pointing to the local server (itselft) in the Client Network utility. It's alias is ALIAS.
Step 2. I create a view in pubs database
CREATE VIEW linked_server_view AS
SELECT * FROM ALIAS.master.dbo.sysobjects
Step 3. The following statement will return a SQLOLEDB Provider error:
SELECT * FROM ALIAS.pubs.dbo.linked_server_view
ERROR:The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
If anyone has a solution or a workaround, I'd be grateful!!