Questions tagged [ssms]

SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.

SQL Server Management Studio is the tool shipped by Microsoft for managing and querying SQL Server databases. It also provides management facilities for Integration Services, Analysis Services and Reporting Services.

Although the tool is based on the Visual Studio framework it does not plug into a Visual Studio development environment such as Visual Studio Pro or BIDS. Some key features provided by SSMS include:

  • Query facilities for SQL Server and SSAS.

  • A tree based system explorer for the supported components that allows various objects such as databases installed on the system to be inspected and managed. Management facilities are provided for SQL Server, SSAS, SSIS and SSRS.

  • Launchers for other management tooling such as the profiler.

  • In later versions a basic facility is available to group sets of files together into projects.

SSMS is descended from the older 'Query Analyser' product produced by Microsoft and is often preferred as a SQL query development tool by people working with SQL Server. Command line based query and management tools such as SQLCMD, ASCMD and RS are also available, mainly designed to integratee into scripting environments.

1208 questions
112
votes
6 answers

SQL Server Management Studio 18 won't open (only splash screen pops up)

I just installed SSMS 18 GA on a computer with only VS2019 installed, and when I try to open SSMS the splash screen will come up, but then the process exits. Running ssms with the -log parameter reveals an error message: CreateInstance failed for…
Mitch
  • 2,618
  • 2
  • 17
  • 23
78
votes
2 answers

How to add the Debug button to SSMS v18?

The Debug button is present on this version of SSMS: But it is not present on version 18, preview 4: I have tried in several ways to add the Debug button to my SSMS but not successful. Is there a way to add the Debug button to SSMS v18?
Marcello Miorelli
  • 15,417
  • 50
  • 140
  • 271
59
votes
7 answers

.bak file not visible in any directory in SSMS

I have a .bak file created today by someone else, manually created through SSMS 2008 R2. I'm trying to manually restore the database, unfortunately the file isn't appearing when I go to browse it. I can script the restore process, but I've seen this…
Sean Long
  • 2,206
  • 5
  • 21
  • 29
45
votes
4 answers

Can I install SQL Server Management Studio locally?

Can I install SQL Server Management Studio on my desktop to access a database on a SQL Server 2012 instance? If so, where can I find the installer? Google searches only return 'express' versions whereas, I am looking for the full SQL Server…
pgunston
  • 665
  • 2
  • 7
  • 10
42
votes
7 answers

Why should I use Visual Studio 2010 over SSMS for my database development?

Visual Studio 2010 introduces database projects and a whole array of related features that supposedly facilitate database development. I've used SQL Server Management Studio (SSMS) for many years to do my database development without issue. Why…
Nick Chammas
  • 14,490
  • 17
  • 74
  • 121
40
votes
4 answers

Formatting T-SQL in SSMS 2012

According to this Microsoft document: http://msdn.microsoft.com/en-us/library/ms174205.aspx I am supposed to be able to use ctrl+K then ctrl+D to format my SQL documents in SQL Server Management Studio 2012 but when I use that combo I get the…
user11512
39
votes
1 answer

How do I read Query Cost, and is it always a percentage?

I'm currently studying for SQL 70-433 (the Microsoft Certification exam), and I'm getting very confused about the "query cost" performance metric. According to any documentation I could find via Google, the query cost is a percentage figure, and…
Born Again Geek Girl
39
votes
6 answers

Management Studio System.OutOfMemoryException

I'm using Microsoft SQL Server 2012 and trying to run a simple query against it within Management Studio. I'm getting the following error (in SSMS, running on the server): An error occurred while executing batch. Error message is: Exception of…
Ben Durkin
36
votes
21 answers

SQL Server Management Studio slow opening new windows

After upgrading both SQL Server and Management Studio from 2008 to 2012, Management Studio 2012 is very slow when new query windows and dialog boxes are opened. Even right clicking on tables is slow. There is typically at least a 5 second delay…
David S.
  • 461
  • 1
  • 4
  • 4
36
votes
4 answers

Why does SQL Server return some rows while still executing the query, and sometimes not?

There are queries where when we hit "execute", it shows some rows and it keeps growing, but the query is not over yet. Yet sometimes, it waits until the end of the query. Why does this happen? Is there a way to control this?
Racer SQL
  • 7,228
  • 10
  • 55
  • 111
33
votes
6 answers

What does a RED X on a database user mean?

I created two new AD groups and added them as Users of a database, but their icons show with a red X. What does this mean?
user18718
32
votes
1 answer

How to uninstall SQL Server Management Studio 2012?

How to uninstall SQL Server Management Studio 2012? ControlPanel's "Uninstall or change programs" (in Windows 7 Prof) gives a row of entries: while internet search results always tell: "click Microsoft SQL Server 2005, and then click Change"…
Fulproof
  • 1,382
  • 2
  • 25
  • 34
29
votes
4 answers

How to clone a user in SQL Server 2008 R2?

Is there a way to clone users' security and permissions in Microsoft SQL Server, preferably using the SQL Server Management Studio GUI?
sweetritz
  • 351
  • 1
  • 5
  • 11
29
votes
6 answers

SQL Server Management studio slow connection or timeout when using Windows Authentication

I'm getting extremely long delays (10~30 seconds) in SQL Server Management Studio 2014 when attempting to connect to a SQL Server 2012 instance over TCP using Windows Authentication. This happens when connecting Object Explorer or a new blank query…
Jordan Rieger
  • 411
  • 1
  • 5
  • 13
28
votes
4 answers

Copying (hundreds of) tables from one server to another (with SSMS)

I have several hundred (currently 466, but ever growing) tables I have to copy from one server to another. I have never had to do this before, so I'm not sure at all on how to approach it. All the tables are in the same format: Cart
Der Kommissar
  • 1,493
  • 1
  • 15
  • 27
1
2 3
80 81