Stack Overflow
Stack Overflow

Questions tagged [ssms-2012]

Microsoft SQL Server Management Studio 2012

Microsoft SQL Server Management Studio (SSMS) 2012 is an easy-to-use graphical management tool for managing SQL Server 2012 Edition with Advanced Services.

The tool includes both script editors and graphical tools which work with objects and features of the server.

258 questions
70
votes
9 answers

CTRL+R does not hide the Query Result window in SSMS

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 happened. At the bottom of SSMS I noticed that the…
RLH
  • 15,230
  • 22
  • 98
  • 182
34
votes
2 answers

How to enter 'NULL' into SSMS cell?

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 meant the NULL value instead of the 'NULL' text. Which…
Michel de Ruiter
  • 7,131
  • 5
  • 49
  • 74
29
votes
2 answers

Microsoft SQL Server vs. SQL Server Management Studio

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?
hrskrs
  • 4,447
  • 5
  • 38
  • 52
24
votes
3 answers

Can't Export Data-tier Application for Azure

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 error: Error SQL71564: Element Login: [myusername]…
user1477388
  • 20,790
  • 32
  • 144
  • 264
22
votes
2 answers

Where is the SQL Query Analyzer in SQL Server Management Studio 2012

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 SQL Query Analyser. Any Input will be appreciable.
user2516685
  • 285
  • 1
  • 3
  • 7
22
votes
1 answer

How to connect to SQL Server CE file using SSMS

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 object browser, but that isn't an option. Is there…
zimdanen
  • 5,508
  • 7
  • 44
  • 89
18
votes
8 answers

Source Type 200 in SQL Server Import and Export Wizard?

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 checked "Write a query to specify the data to transfer",…
kabichan
  • 1,063
  • 4
  • 19
  • 49
16
votes
4 answers

Activity Monitor always Paused in SSMS 17.8.1

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 happens on a variety of SQL Servers and SQL Server…
Izulien
  • 363
  • 1
  • 4
  • 10
14
votes
3 answers

Results in Grid is not showing in SQL Server

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 still I couldn't see the results in grid. I even hit the "Reset…
Mar1009
  • 721
  • 1
  • 11
  • 27
14
votes
2 answers

What shell is SSMS 2012 based on and how can I darken the theme?

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 SSMS 2012 UI elements darker. I've googled to no…
sheldonhull
  • 1,807
  • 2
  • 26
  • 44
13
votes
5 answers

Is there a way to expand the column list in a SELECT * from #Temp_Table in SSMS?

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 the clipboard? I know that you can use the columns…
Daniel E.
  • 2,029
  • 3
  • 22
  • 28
10
votes
7 answers

Opening .sql files in SSMS 2012 as default program and with existing instance

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. Dragging .sql file to the query window works…
sheldonhull
  • 1,807
  • 2
  • 26
  • 44
9
votes
1 answer

SQL Server Management Studio 2012 - Deploy Database to SQL Azure - SQL71501 User has an unresolved reference to Login

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) Validation of the schema model for data package failed.…
Caius Jard
  • 72,509
  • 5
  • 49
  • 80
9
votes
1 answer

How to disable nesting of triggers at table or trigger level in SQLServer?

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?
Jim
  • 323
  • 2
  • 12
9
votes
1 answer

Tab-Tab snippet expansion doesn't work in SQL Server Management Studio?

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 work. (I'm using SSMS 2012.) In both environments you…
Herb Caudill
  • 50,043
  • 39
  • 124
  • 173
1
2 3
…
17 18