How to fix Msg 7390 - The requested operation could be performed

Question: I have a SQL Server Linked Server configured , pointing to an ODBC - accessing a MongoDB driver . The test connections all work OK - and no problems running an OPENQUERY select statement using the Linked Server. But when I attempt to run an EXECUTE AT , and attempt to INSERT the data into a #temp table - I get an error message: declare @myStmt varchar(max) set @myStmt = 'select _id from mytable' CREATE TABLE #temp2 (_id varchar(50) ) INSERT INTO #temp2 EXECUTE (@myStmt) AT my_linked_server DROP TABLE #temp2 Msg 7390, Level 16, State 2, Line 6 The... Read more →

How to enable MSDTC XA transactions with Powershell

Question: I've read your post on Enable XA transactions for SQL Server , which outlines how to enable XA transactions via the Computer Services module. I'd like to integrate the enabling of XA transactions as part of a scripted SQL Server installation, whoch includes enabling XA transactions for some applications. I'm using Powershell to develop the script . How can I see the current value and also change the value to enable XA ? Answer: It is possible to access and set the MSDTC XA Transactions values using Powershell . You need to make sure your current login has the... Read more →

Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction

How to recover a suspect database in SQL Server? I’ve restarted a SQL Server after an outage to discover a suspect database in SQL Server. A quick check on the SQL Error Logs reports Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction (xxxxxxxxx). Fix MS DTC, and run recovery again. What should I do? Currently the database is in suspect mode and I have not done anything. Answer: Before you do anything check the last full backup you have in place. Although at this point you do not need to complete... Read more →

How to delete Distributed Orphaned Transactions

how to delete distribution transaction managed through the Microsoft Distributed Coordinator Read more →