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...

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014? In SSMS 2012, if I go to tools, it showed up in the list. In SSMS 2014, it doesn't. I tried t...

Is it possible to set the SSMS theme to all dark? I really like the dark theme in Visual Studio and SSMS is built on top of the VS shell. I saw this SQL Server Management Studio Skin / Appear...

I am trying to export the results of a query to CSV and then ultimately Excel. My issue is, one of my columns has commas in it and the commas interrupt Excel parsing the CSV in the correct places...

Randomly when writing SQL queries in SSMS 2014, I'll get a popup that "Visual Studio has encountered an exception. This may be caused by an extension" along with a tip that I can run the ...

I'm using SSMS 2014. I am able to insert a snippet but they don't seem to respond to shortcuts (ie crproc[tab]) Is this feature known to work? <?xml version="1.0" encoding="utf-8" ?> <C...

I am trying to export a rather simple database using the Export Data-tier application and keep getting the following error: One or more unsupported elements were found in the schema used as part o...

There is 2 tables called Students stuID camID FK Campus camID PK camName I am trying to find the campuses with more than 4 students that include the camName, camID, (number of students) ...

I am running the below query: SELECT ReceiptVoucherId, VoucherId, ReceiptId, rvtransactionAmount, AmountUsed, TransactionTypeId FROM [Scratch].[dbo].[LoyaltyVoucherTransactionDetails]...

I recently discovered an extension for visual studio that allows you to specify a watermark for the code window. This extension can be found on github here. https://github.com/nategreenwood/VSEdit...

Similar to this question Visual Studio 2013 High DPI on 4k Screen to which I had posted an answer but have now removed since uncovering the issue below. I too have just bought a new 4K laptop and ...

I am trying to restore a .bak file in my SQL Server using SSMS. However I am unable to find the Restore Database option in the menu bar, when I right-clicked on Database. What can be the possible...

I try to rename a database or a table in SSMS 2014 (with CU6 applied), by clicking and selecting the DB or table in the Object Explorer and then pressing F2 to edit the name. The Delete key on my k...