Recently I've found out, that there's an option to include most commonly used queries to be executed by clicking a button on SSMS toolbar. You can do that by following these steps: Right mouse c...

SQL Server - SSMS Can we change the SSMS query tab color based on connection string? Lets say I'm connecting to different environments Prod / Dev / UAT/ Test etc... or I want to group my servers b...

From my local computer I am using SQL Server 2016 Management Studio client (SSMS) to connect to a SQL Server installed on a remote computer. I connect using Windows Authentication method. My SQL S...

Today I installed version 13.0.15800.18 of Microsoft SQL Server Management Studio (SSMS) [2016-09-20, 16.4], and now it refuses to edit my stored procedures. I even tried a slightly older version o...

Years ago I wrote an addin to do specific things I want in SSMS. I use it all the time and have gone through the pain of working out how to get it running again each time a new version of SQL serve...

We are getting below error msg in the pop-up windows, when trying to view the generated XML in SSMS - Sql Server. Microsoft SQL Server Management Studio Unable to show XML. The following e...

Whilst installing SSMS 2016, I get the following error and setup terminates: SQL Server 2016 Common Files: A valid destination folder for the install could not be determined. I've tried the fo...

How can I use SSMS 2016 regex replace feature to remove extra spaces and tabs at the end of lines? Example of editor content: select 'tab' , 'space' select 'tabs' , 'spaces' Goal: selec...

In Microsoft SQL Server 2016 Express Management Studio (July 2016) cannot design a new or existing table. Image 1: click on the tables node. Where is the menu option to add a new table? Image 2...

I have a shared hosting. I was happy with it. I was creating new databases on its panel and then I was managing my databases with SQL Server Management Studio. I could add new table by right clicki...