Activity overview
Latest activity by Sergio Rocha
Hi Pam, I would suggest trying the following: 1 - Drop the Shadow Database and then refresh: this should force a rebuild of the Shadow Database 2 - If the above doesn't work and assuming that you are using the default Programmable Objects option (UseRepeatableScriptsForAllObjects), delete the scripts for all the problematic Views and Stored Procedures and add them again / comments
Official comment
Hi Pam,I would suggest trying the following:1 - Drop the Shadow Database and then refresh: this should force a rebuild of the Shadow Database2 - If the above doesn't work and assuming that you are ...
Setting up OpenID Connect (OIDC) with Entra ID in Redgate Monitor
This article provides specific information on how to use Redgate Monitor's OpenID Connect authentication feature with Redgate Monitor. Please also consult https://documentation.red-gate.com/sm/addi...
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...
SQL Source Control can't access this database - make sure the database is online and you have permission to access it
Besides the causes mentioned in the actual error message (the database being offline or the user used to connect in SSMS not having permissions) this can also be caused by Certificate Validation is...
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...