Posts
Sort by recent activity
Recently installed SSMS 19.1 and second instance shuts down
Recently installed Microsoft SQL Server Management Studio 19.1. When I open an additional instance of SSMS on my second monitor and try to <Right-Click> on an Entity to Script Stored Procedure as t...
Comparing just one SQL Server Stored Procedure between Environments
Is there a written procedure or YouTube that explains how to compare just one SQL Server Stored Procedure between Environments?I don't want to compare every SQL Server Stored Procedure...Just oneAn...
Migrate VM SQL Server Entities to Azure DevOps Source Control
I have been tasked to migrate our existing SQL Server entities, Table Definitions, SQL Server Stored Procedures, etc. that reside on our VM Servers to Azure DevOps and Source Control. I have no ide...
Highlight Data Columns on an INSERT
I believe the Red Gate Tool for SQL Server Management Studio used to highlight the column and the data on an INSERT Statement. This was really useful when I had to INSERT lots of data columns. This...
T-SQL Formatting Styles
We are in the process of updating our T-SQL Standards which may include formatting style.Just wondering if there is a general web site for Redgate SQL Formatting Styles...what the style looks like....
How do we compare a SQL Server Stored Procedure between two environments
We have Redgate SQL Compare 13 Version 13.6.We also have SQL Data Compare 13 Version 13.6I get confused as to which Product to use when. Which product do I use to compare one SQL Server Stored Proc...
SQL Change Automation Errored Out because of a script referencing a Foreign Key
Trying to re-baseline my project and Deploy Project resulted in an Error wehere a Script is referencing a Foreign Key that is not defined to my (localdb). How can I get around this? The script it i...
Using SQL Compare to dump data with Table differences
We are using SQL Compare to dump our Production data to our Sandbox environment. a few of the tables have changed between the Production environment and our Sandbox and the "Database" deployment is...