I couldn't see the results in grid pane, so I did the following: Tools > Options > Query Results > Results to Grid > uncheck the "Discard results after execution" check box But st...

I came across this very weird issue today. When I open SQL server management studio it shows up in the task bar but somehow it never appears on my screen, even when I do alt+tab to switch to SQL se...

As seen here LINK you can hover over the * in a SELECT * from... and a tooltip will come up with a list of the columns represented by that *. Is there a way to copy the text from the tooltip to th...

When I try to manage an Azure Database query in SQL Managements Studio 2012 I see that the "Design in Query Editor" option is disabled. It is enabled for other databases but not for Azure. Is there...

Whenever I open the Activity Monitor in SQL Server Management Studio 17.8.1(14.0.17277) the overview always switches to (paused). Even if I choose resume, it quickly changes back to paused. This h...

Installation of SSMS 2012 alongside any other existing SSMS installation, such as SSMS 2008 R2 has a problem with setting the default program for opening .SQL files to the new SSMS 2012 version. ...

I just upgraded from SSMS 2005 to 2012. Previously, I could hit CTRL+R and the Query Results windows would disappear. After I upgraded to SSMS I ran a query and, out of habit, hit CTRL+R. Nothing ...

Using SQL Server 2012, is it possible to have nested triggers enabled at the server/database level but to disable nesting on one specific table/trigger?

In SQL Server Management Studio 2012, I was typing/pasting data into a table (via Edit Top 200 Rows). Whenever I typed/pasted NULL in a cell, a NULL value was inserted. Apparently it thought I mean...

I am trying to create a .bacpac file of my SQL 2012 database. In SSMS 2012 I right click my database, go to Tasks, and select Export Data-tier Application. Then I click Next, and it gives me this...

What is the difference between Microsoft SQL Server and SQL Server Management Studio (SSMS) and how can I integrate SSMS in Visual Studio 2012 so I can use database diagrams?

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

I am trying to build an email and have run into an issue. When the stored procedure runs, I get the following error message. Msg 14624, Level 16, State 1, Procedure sp_send_dbmail, Line 242 At...

When running code, SSMS 2012 is writing (1 row(s) affected) into the messages window for every line in mydataset. This isn't unexpected (see details below) but is there any way to suppress these me...

I have some SQL thats getting run and it is taking to long to return the results / parse / display, etc. application. I have SQL Server Management Studio 2012 installed.but i am not able to find S...

I am trying to import data from one database in a server to a new table in a different server, using SQL Server import and Export Wizard. (SQL Server Management Studio 2012) In the wizard, I check...

While trying to do anything related to deploying to Azure/creating a BACPAC in SSMS 2012 I encounter error for each of 3 users in my database (who are not the user that is currently logged on) V...

80-90% of the time I spend in SQL Server Management Studio is spent dealing with the same 5 or 6 tables/views/stored procedures, out of the 100+ in some databases. It would be wonderfully helpful...

I have a dark query editing environment, but the object explorer and other elements default to the white background. I really like VS 2012 dark theme, and was hoping someone knew of a way to get SS...

In Visual Studio, you can invoke a snippet by typing its shortcut followed by tabtab. For example, typing proptabtab gives you this: In SQL Server Management Studio (SSMS), this doesn't seem to ...

I am using SSMS 2012 and trying to connect to the SDF created by Orchard. According to this answer, I should be able to select SQL Server Compact Edition as the Server type when connecting my objec...