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.
1,259
questions
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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?
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 ...
31
votes
4
answers
57k
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?
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 ...
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 ...
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 ...
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 ...
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?
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.
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, ...
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 ...
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?
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 ...
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 ...
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. ...
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 ...
24
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
18
votes
3
answers
34k
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 ...
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?
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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?
...
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?
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 -&...
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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 ...