Articles
                          
                            Sort by recent activity
                          
                          
                        
                      
                      
                        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...
                      
                    
                      
                        Unable to resolve package source
                        
                        
                        
                      
                      
                      
                  
                    You get the following error message when running a SQL Change Automation Powershell:
Unable to resolve package source 'https://www.powershellgallery.com/api/v2'.No match was found for the specified...
                      
                    
                      
                        How to Link SQL Source Control to TFS
                        
                        
                        
                      
                      
                      
                  
                    Git in TFS/VSTS
If you're using TFS/VSTS with Git-based version control, you can't use TFS mode to link. Instead, you need to link in Git mode.
In the Object Explorer, select the databas...
                      
                    
                      
                        error 5(Access is denied.) while attempting to open or create the physical file
                        
                        
                        
                      
                      
                      
                  
                    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...
                      
                    
                      
                        How to link to an existing SVN repository
                        
                        
                        
                      
                      
                      
                  
                    
Linking to SVN
After you link
Linking to SVN
To do this, you will need to be able to link to the folder where the RedGate.ssc file is located.
In the Object Explorer, select the database you wan...
                      
                    
                      
                        SQL Change Automation Installation freezes at 99%
                        
                        
                        
                      
                      
                      
                  
                    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...
                      
                    
                      
                        SQL Change Automation Powershell permissions
                        
                        
                        
                      
                      
                      
                  
                    When working with SQL Source Control Projects, SQL Change Automation PowerShell requires the same permissions as SQL Compare:
Permissions required to use SQL CompareBuild step specific:
Besides the...
                      
                    
                      
                        Objects changed by unknown
                        
                        
                        
                      
                      
                      
                  
                    The Changed by column in the Commit Tab might list objects as changed by Unknown.
Please see the following documentation for troubleshooting steps and workarounds:
Object changed by Unknown 
                      
                    
                      
                        Sequence contains more than one matching element
                        
                        
                        
                      
                      
                      
                  
                    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...
                      
                    
                      
                        Server Aliases not working when connecting with SQL Compare/SQL Data Compare
                        
                        
                        
                      
                      
                      
                  
                  
                When you try to connect to an instance using a server alias, you get the error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
and you ...