Comments
Sort by recent activity
If running change automation from azure devops using an agent installed on server what steps do I need to take to ensure I have the latest SCA Powershell module? Thanks! / comments
If running change automation from azure devops using an agent installed on server what steps do I need to take to ensure I have the latest SCA Powershell module? Thanks!
I have a pipeline in azure devops which uses Redgate change automation and receives the following error with linked server when release runs - System.Management.Automation.CmdletInvocationException: Applying update script failed: The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "XXXXXXXXXX" was unable to begin a distributed transaction.
LegacyVSTSPowerShellHost.exe completed with return code: -1.
I have tried changing the transaction isolation level to Read Uncommitted in the build but same error.
How do I set it to no transactions from the gui?
/ comments
I have a pipeline in azure devops which uses Redgate change automation and receives the following error with linked server when release runs - System.Management.Automation.CmdletInvocationException...