Make sure the “Distributed Transaction Coordinator” service is running in the Window Services. Make sure the Security settings is configured correctly in Windows Component Services. Make sure firewall is not being blocked in the “Allow apps to communicate through Windows Firewall” section of Windows Firewall Control Panel section. If SQL Server Linked Server is setup,... » read more
Error: OLE DB provider “SQLNCLI11” for linked server “xxxxxx” returned message “The partner transaction manager has disabled its support for remote/network transactions.”. Msg 7391, Level 16, State 2, Procedure dbo.xxxxxx, Line 1 [Batch Start Line 14] The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “xxxxxx” was unable to begin... » read more
Use Transact-SQL To manually fail over an availability group: Connect to the server instance that hosts the target secondary replica. Use the ALTER AVAILABILITY GROUP statement, as follows:ALTER AVAILABILITY GROUP group_name FAILOVER In the statement, group_name is the name of the availability group.The following example manually fails over the MyAg availability group to the connected secondary replica: Sources: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/perform-a-planned-manual-failover-of-an-availability-group-sql-server?redirectedfrom=MSDN&view=sql-server-ver15
TestScript.cmd Result What is your name: John Specify Project?: 123 Name=John Project=123 Press any key to continue . . .
TestScript.cmd Result D:\>TestScript 1 2 First Parameter: 1 Second Parameter: 2 Press any key to continue . . .