Skip to main content

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.

Filter by
Sorted by
Tagged with
113 votes
6 answers
102k views

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 ...
Mitch's user avatar
  • 2,638
85 votes
2 answers
174k views

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 ...
Marcello Miorelli's user avatar
62 votes
7 answers
107k views

.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 ...
Sean Long's user avatar
  • 2,236
45 votes
4 answers
103k views

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 ...
pgunston's user avatar
  • 665
42 votes
7 answers
14k views

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 ...
Nick Chammas's user avatar
  • 14.7k
40 votes
6 answers
176k views

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 ...
user avatar
40 votes
4 answers
80k views

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 ...
user avatar
39 votes
1 answer
34k views

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 ...
user avatar
38 votes
22 answers
63k views

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. ...
David S.'s user avatar
  • 481
36 votes
3 answers
11k views

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 ...
Racer SQL's user avatar
  • 7,386
36 votes
3 answers
61k views

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?
user avatar
32 votes
1 answer
80k views

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 ...
Fulproof's user avatar
  • 1,382
31 votes
4 answers
58k views

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's user avatar
  • 371
30 votes
6 answers
53k views

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 ...
Jordan Rieger's user avatar
28 votes
4 answers
9k views

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 ...
Der Kommissar's user avatar
27 votes
5 answers
41k views

How to make SSMS upper case keywords

I recently started using Management Studio 2012. When using MySQL Workbench, a handy feature was that I could stay all in lower case and any reserved word (like SELECT, INSERT) would convert to upper ...
David Folksman's user avatar
27 votes
1 answer
18k views

How can I force SQL Server Management Studio to update the IntelliSense cache?

IntelliSense in SSMS isn't updating unless I shut it down and restart. I've tried disconnecting from the server and reconnecting while the SSMS session is active, but that isn't working. Steps to ...
Head of Catering's user avatar
27 votes
2 answers
14k views

How to disable "Completion time:..." in SQL Server Messages window

Every query I run in SSMS append the annoying message: "Completion time:...". How can I disable that text?
user avatar
26 votes
6 answers
33k views

How to remove line breaks in SSMS?

I am dealing with SQL that looks as follows create procedure as begin Notice the large gaps e.g. between as and begin. How can I remove these? I used SQL formatter but this is not working.
Anand's user avatar
  • 305
26 votes
10 answers
233k views

"Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio

I have created a table testtable inside the database testbase that have the following structure: product_no (int, not null) product_name (varchar(30), not null) price (money, null) expire_date (date, ...
Jack's user avatar
  • 2,509
26 votes
1 answer
3k views

Why does a simple loop result in ASYNC_NETWORK_IO waits?

The following T-SQL takes about 25 seconds on my machine with SSMS v17.9: DECLARE @outer_loop INT = 0, @big_string_for_u VARCHAR(8000); SET NOCOUNT ON; WHILE @outer_loop < 50000000 BEGIN SET ...
Joe Obbish's user avatar
  • 32.2k
25 votes
1 answer
7k views

Suppressing the SSMS prompt to save changes

Is it possible to configure SQL Server Management Studio (SSMS). so that the dialog box shown above does not appear when I close an unsaved query window?
Ario's user avatar
  • 1,042
25 votes
3 answers
13k views

Was Management Studio removed from SQL Server 2016 installation media?

I just tried installing SQL Server 2016 Enterprise but I noticed that Management Studio was not installed by default. I also noticed there is a separate link to SSMS in the installation guide which ...
Mark13426's user avatar
  • 579
25 votes
6 answers
37k views

SQL Server Management Studio 2012: How to have folders in the SSMS project?

I'm using SSMS 2012 to talk to the SQL server 2012 and Azure SQL servers we use. I admit I'm not a SQL expert so I've been saving most of my SQL scripts for future reference. I've quickly run into 20 ...
DeepSpace101's user avatar
25 votes
1 answer
142k views

Find all the queries executed recently on a database

[I am a beginner level T-SQL Programmer] [..and hopefully I am on the right stack exchange site] I would like to get a list of all the queries I executed (in the least, those I executed today since ...
Prashanth Tilleti's user avatar
24 votes
7 answers
135k views

Could not find the Server Agent in SSMS

I am following the guide - http://www.sqlchicken.com/2009/07/how-to-create-a-server-side-trace-with-sql-profiler/ which is working until I reach Step 8 Now to schedule your newly created script. ...
Jack's user avatar
  • 2,509
24 votes
5 answers
36k views

Suppress SQL Server Management Studio auto complete

Is there a way to temporarily suppress SQL Server Management Studio's auto-complete while typing a query? I don't want to disable auto-complete completely just say hold down some key while typing in a ...
Jack's user avatar
  • 341
21 votes
3 answers
5k views

Is it OK to blindly add missing indexes?

I often use SSMS to test my slow stored procedures for missing indexes. Whenever I see a "Missing Index (Impact xxx)" my kneejerk reaction is to just create the new index. This results in a faster ...
O.O's user avatar
  • 678
21 votes
3 answers
46k views

Can I use SQL Server Management Studio 2012 on a 2008 server?

My school is using SQL Server 2008. Last time I used it I only installed (at home) SQL Server Management Studio 2008 part, and used VPN to connect to school's server. Now I want to install SQL Server ...
user avatar
20 votes
5 answers
160k views

Download SQL Server Profiler for SQL Server Management Studio

How can I profile a SQL Server 2008 database to see code that's being executed on a particular database? I remember using the SQL Server profiler, but I don't see it in SQL Server Management Studio ...
JustBeingHelpful's user avatar
19 votes
4 answers
24k views

SSMS Tools Pack Alternative [closed]

Are there any tools out there comparable to SSMS Tools Pack 2012? The licensing ($30 per machine, $100 for any number of machines... for 3 months) leaves a lot to be desired and I wasn't sure of what ...
WernerCD's user avatar
  • 1,225
19 votes
2 answers
4k views

Why can't I use NEWSEQUENTIALID() as the default value for my column?

I'm trying to create a table in Management Studio and after reading about the new (from SQL 2005 on) NEWSEQUENTIALID() function, thought I'd give it a go. This is what I'm doing: But it's not ...
immutabl's user avatar
  • 809
18 votes
3 answers
35k views

Stuck task in management studio, how do you handle them?

After clicking on "Take database offline" in management studio this message stays hang and won't close if you click on close. What's a good way to deal with stuck jobs like these in management studio ...
A_V's user avatar
  • 1,364
18 votes
3 answers
56k views

Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio

When right-clicking on a table and selecting "select top 1000 rows", I get this error: Is there any workaround, other than the obvious upgrade to SQL Server 2014?
Marcello Miorelli's user avatar
17 votes
1 answer
2k views

Poor SQL Server performance when management studio closed

I've noticed a strange behaviour of SQL Server 2008 r2 express: usually my query execution time is ~650ms, but if I open Management Studio and run any simple query (for example SELECT * FROM ...
Demchenko Anton's user avatar
17 votes
2 answers
5k views

Are the cost percentages in this SQL Server plan over 100% for a valid reason?

I'm looking through the plan cache, looking for low-hanging optimization fruit and came across this snippet: Why are many of the costs listed above 100% ? Shouldn't that be impossible?
Hannah Vernon's user avatar
  • 70.1k
17 votes
1 answer
25k views

best way to run sql server management studio on linux

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker. I want to use sql server management studio to manage the server. SO far now, I have a windows 7 enterprise with with ...
opensas's user avatar
  • 347
16 votes
5 answers
22k views

SQL Server 2012 is putting [brackets] around Table and Column Names

When you drag the Columns folder to editor Window, the full list of Columns are added without Brackets. If you drag columns individually they have Brackets. Is there anyway to turn that off? I'm ...
Gordon Bell's user avatar
15 votes
12 answers
86k views

Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery

I have received a database file and the instructions for loading it is to install SQL Server 2005 and then attach it using SQL Server Management Studio. After installing everything, I tried to attach ...
MxLDevs's user avatar
  • 339
15 votes
4 answers
33k views

Show data and disk use breakdown by table

I have a SQL Server 2008 R2 database being used by several deployed programs. Question: Is there an easy way to display how much space each table consumes, for all of the tables in the database, and ...
Dronz's user avatar
  • 253
15 votes
3 answers
15k views

Can I connect to a SQL Server 2000 instance from SQL Server Management Studio 2012?

I would like to update my development machine to SQL Server 2012 but I still manage some (very old) SQL Server 2000 machines. Wil my 2012 SSMS be able to connect to those SQL Server 2000 machines? ...
Michael Haren's user avatar
15 votes
2 answers
14k views

Is SQL Server 2012 Management Studio "Express" any different?

Are there any differences from the version of SSMS that comes as part of the SQL Server 2012 Enterprise Installer and the SQL Server 2012 Express Management Studio?
Kyle Brandt's user avatar
  • 2,345
15 votes
4 answers
18k views

Restore Database wizard won't open in SSMS 2014

On a dev machine running Windows Server 2012 R2, I just upgraded SQL Server from 2012 to 2014. Using SQL Server Management Studio 2014, when I right-click a database and go to Tasks -> Restore -&...
Josh Bula's user avatar
  • 251
14 votes
5 answers
47k views

Save Results as CSV *with* headers in SSMS

With SQL Server 2008 R2, when I save the results as a CSV there are no headers. I can work around this by copying and pasting with the "Copy with Headers" , or just grab the headers and paste them in ...
Kyle Brandt's user avatar
  • 2,345
14 votes
3 answers
14k views

Why is SSMS inserting new rows at the top of a table not the bottom?

Whenever I manually insert a row into a table in SQL Server Management Studio 2008 (the database is SQL Server 2005) my new row appears at the TOP of the list rather than the bottom. I'm using ...
Ben Brocka's user avatar
  • 2,063
14 votes
3 answers
30k views

Microsoft SQL Server local report culture is not supported: 3072 is invalide culture identifer

I am using Windows 10, language Serbian, SQL Management Studio 2016 and can't use Database reports because there is error: An error occurred during local report processing Culture is not ...
Jelena's user avatar
  • 143
14 votes
1 answer
2k views

Why is "Lookup" colored as a function reserved word in SQL Server?

In SSMS 2208, the identifier "Lookup" is colored hot pink as if it were a function (same color as, say, "Power" or "Convert"). Why? I cannot find it in the official list of reserved words. Searches ...
ErikE's user avatar
  • 4,305
13 votes
4 answers
6k views

SQL Server Management Studio for a remote database

With a SQL Sever database which is on a remote hosted dedicated server I can work using SQL Server Management Studio installed either on the same server or on my local computer. I the first case I ...
rem's user avatar
  • 1,555
13 votes
1 answer
63k views

SQL Server error "Missing family sequence number 2"

I'm trying to restore a local database on my server, but I'm having problems with the backup. I did a file .bak but every time I try to load it on the server it doesn't let me. Here's a screenshot of ...
E.Rawrdríguez.Ophanim's user avatar
13 votes
1 answer
13k views

Move folder of SQL Server LocalDB instances from the default location

I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping ...
Piedone's user avatar
  • 233

1
2 3 4 5
26