Articles
Sort by recent activity
High RAM usage in the Credential Guard service on servers hosting the Base Monitor service
DescriptionEver increased RAM usage in the Credential Guard service (lsalso.exe) in the server that hosts the Redgate Monitor Base Monitor service. Eventually, the server might crash.CausesThis app...
The operation could not be performed because OLE DB provider ... for linked server ... was unable to begin a distributed transaction (SQL Compare)
This error occurs because of the Transaction Isolation Level.
By default, SQL Compare uses the Serializable Transaction Isolation Level, however this deployment requires a Transaction Isolation Lev...
Body of Generated HTML Document is Blank
The body of the document you've generated using SQL Doc appears blank when you open it on a browser
To fix this, generate the documentation again with the Use frames option disabled.
This is a defa...
An error occurred during the pre-login handshake
If you receive the error message:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate...
The target principal name is incorrect
If you receive the error message:
Microsoft.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process (provider: SS...
Could not install SqlChangeAutomation from any registered PSRepository
This can be caused by connection issues to the PowerShell Gallery or because the connection does not meet the encryption standard required to connect to the PowerShell Gallery, please see this arti...
System.Exception: No match was found for the specified search criteria and module name 'SQLChangeAutomation'. Try Get-PSRepository to see all available registered module repositories
The SQL Change Automation add-on will attempt to download the latest version of the SQL Change Automation (SCA) Module from the PowerShell Gallery before carrying out the task at hand.
This allows ...
No match was found for the specified search criteria and module name 'SqlChangeAutomation'.
This issue can occur when using when you are using a SQL Change Automation Azure DevOps add-on, using an older task version, and the self-hosted agent you are using cannot download the SQL Change A...
Online index operations can only be performed in Enterprise edition of SQL Server
This error occurs because SQL Change Automation uses SQL Server Express LocalDB as the default Temporary Database Server for the schema validation operation.
If you are using a PowerShell Script:
U...
Meanings of the colored dots in the SSMS Object Explorer for SQL Source Control
In the object explorer of SQL Server Management Studio (SSMS) SQL Source Control uses colored dots to indicate several different status types for the status of SQL Source Control or the type of cha...