How can we help you today? How can we help you today?
Sergio Rocha
Activity overview Badges (0) Articles (30) Posts (0) Comments (2)

Articles

Sort by recent activity
Sequence contains more than one matching element
  1. Product help
  2. SQL Multi Script
The error message "Sequence contains more than one matching element" when opening SQL Multi Script can usually be worked around by recreating the Application.dat file.1. Make sure SQL Multi Script ...
Edited 1 follower 0 comments -4 votes
The 'SqlSourceControlPackage' package did not load correctly
  1. Product help
  2. SQL Source Control
This issue can have multiple causes: Using an outdated SQL Source Control version SOC is compatible with the versions of SSMS available at the time of its release. It is good practice to always mak...
Edited 2 followers 0 comments -23 votes
High RAM usage in the Credential Guard service on servers hosting the Base Monitor service
  1. Product help
  2. Redgate Monitor
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...
Edited 0 followers 0 comments 0 votes
Could not install SqlChangeAutomation from any registered PSRepository
  1. Product help
  2. SQL Change Automation
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...
Edited 2 followers 0 comments -2 votes
Meanings of the colored dots in the SSMS Object Explorer for SQL Source Control
  1. Product help
  2. 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...
Edited 1 follower 0 comments 1 vote
error 5(Access is denied.) while attempting to open or create the physical file
  1. Product help
  2. SQL Change Automation
This error can occur when using SQL Change Automation Powershell, with the default option of validating the schema folder in LocalDB, and you have LocalDB 2017 installed.  This is caused by a bug i...
Edited 1 follower 0 comments -2 votes
The operation could not be performed because OLE DB provider ... for linked server ... was unable to begin a distributed transaction (SQL Compare)
  1. Product help
  2. SQL Compare/SQL Data 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...
Edited 1 follower 0 comments 2 votes
SQL Change Automation Installation freezes at 99%
  1. Product help
  2. SQL Change Automation
If you find that your SQL Change Automation installation freezes at 99% try installing the extension using the Visual Studio Marketplace (SQL Change Automation Core) before running the installer: h...
Edited 2 followers 0 comments -1 votes
The partition scheme [xxx] on table [yyy] was not found
  1. Product help
  2. SQL Source Control
1. Make sure the repository folder which the database is linked to is solely used by SQL Source Control for that database (it's important to not manually add anything to the folder unless for troub...
Edited 1 follower 0 comments -33 votes
SQL Change Automation Licensing
  1. Licensing help
  2. License management / customer portal
SQL Change Automation (SCA) is licensed per user. All SQL Developers contributing to a Database project that's automated by SCA should have a Flyway Enterprise license. SCA is not sold as a standal...
Edited 1 follower 0 comments -12 votes
Total activity
58
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
26