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.

learn more… | top users | synonyms (2)

-1
votes
2answers
115 views

Browse for Servers does not display local instance

I just installed SQL Server and SQL Server Management Studio but it doesn't show anything in servers list and I don't know how to connect to it. This shows that I have installed SQL Server: ...
0
votes
2answers
380 views

Why does SQL Server Management Studio hang (Not Responding) when connecting to Amazon RDS?

When I use SSMS to connect to a database hosted on Amazon RDS, the IDE hangs (as in goes to "Not Responding) after login. I enter SQL Authentication credentials and click Connect and the login window ...
0
votes
1answer
54 views

Restored database from .bkp file in SQL Server 2014 generates some strange errors [closed]

I have restored the well-known Northwind database and executed a trivial query: Notice the strange error "Invalid object name..." although the query has been executed successfully and both tables ...
0
votes
1answer
28 views

Is there a way to add “distinct” to SSMS IntelliSense?

For the last few versions of SSMS (SQL Server Management Studio), I have noticed that IntelliSense does not contain the word distinct. Is there a way I can add this to the IntelliSense word bank? ...
2
votes
0answers
64 views

Unable to use select top N shortcut on Azure SQL Database via SSMS

Yesterday morning I was able to query my Azure databases via SSMS and the Select Top N menu shortcut. That afternoon I received a couple of alerts that my web applications couldn't connect to the ...
1
vote
0answers
38 views

Change default value for Job Activity Monitor

Is there a way for me to programmatically (some configuration setting in a table / registry entry etc, I'm hoping) change the default value in the Auto Refresh setting to 5 seconds instead of 60, and ...
-1
votes
1answer
478 views

SQL Server Management Studio crashes when attaching an mdf file

After the Windows 10 November update 1511, 10586 I cannot attach my databases with SSMS. It would just say that it has stopped working as shown below I checked the error log and so far this is what ...
0
votes
1answer
24 views

Accessing Registered Servers over Excel

With DBs in different countries, different servers but same structure, I have created registered server to access them when running certain queries for reports on SSMS. Thus far this is ok. However, I ...
3
votes
2answers
59 views

Enabling SQL Instant File Initialization when Restoring to a Network Path

We have a large Read Only SQL DB (SQL 2012) that we’re restoring to a NAS as a current duct tape solution. I had wondered why the restore process seemed to be hanging. Part of my guidance along the ...
1
vote
1answer
138 views

SQL Server Management Studio 2012 Application Cannot Start

I need someone's help. I'm trying to install SQL Server Management Studio on my Laptop Operating System: Windows 7 Service Pack 1 But I got an error message saying: The application cannot start. ...
0
votes
0answers
26 views

List Network Servers on SSMS Browse Servers

My question is how will I show available network server on Browse for Server > Network Servers of Sql Server Management Studio? FYI, I am able to connect to existing and known servers even if it is ...
3
votes
0answers
199 views

How to fix SQL Server Management Studio 2014 IntelliSense when intermittent

Our remote SQL Server was recently upgraded to 2014. I installed SQL Server Management Studio 2014 on my Windows 10 client computer. At first, everything seemed to be going great, until I noticed ...
14
votes
2answers
627 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.
13
votes
3answers
1k views

Why would SQL Server ignore an index?

I have a table, CustPassMaster with 16 columns in it, one of which is CustNum varchar(8), and I created an index IX_dbo_CustPassMaster_CustNum. When I run my SELECT statement: SELECT * FROM ...
2
votes
0answers
32 views

SQL Server - Debugging - How to show parametervalues as HEX

I am writing a script which sets Parameters in the Registry for SQL Server. The following works on some of my servers but not all. DECLARE @Parameters AS VARCHAR(MAX) SET @Parameters = '-T1118' ...
5
votes
3answers
110 views

quickly jump to an object in Object Explorer in SSMS

When expanding a tree with a large number of objects such as the Tables tree in SSMS Object Explorer, is there a method of quickly navigating to the table I am looking for, if I know the exact name or ...
2
votes
1answer
464 views

SSMS 2016 CTP3.1 November Preview (v13.0.800.111) bug? properties error: missing column federated_service_account

Using SSMS 2016 CTP3.1 November Preview (v13.0.800.111) on my laptop, whenever I right click any database object (the database, a table, etc.) I get the below error. TITLE: Microsoft SQL Server ...
2
votes
2answers
128 views

Where can I find a compatible version of SSMS for SQL Server 2016 CTP?

Microsoft seem to have many versions of SQL Server 2016 CTP available at a time to download, at only 2.5GB a piece, but only one version of SSMS 2016 CTP, and if your db engine is the wrong version ...
0
votes
0answers
75 views

SSMS as an End User Tool

Our business has decided to distribute SSMS as an end user tool (Don't laugh). How I can I stop the creation of # temp tables. Our record is a 896gb table!
1
vote
3answers
95 views

How to create a non-sa SQL Server login / access without control server permission

I have SQL Server, and I need to give access to other users to run basic queries (just select on 1 database). I have created a login for a user, and have amended their permissions, but once I deny ...
22
votes
4answers
2k 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 ...
2
votes
2answers
307 views

SQL Server logins and users — assign multiple logins to a single user? [duplicate]

In SSMS, since I can't assign multiple login objects to a single user object, what is a best practice to achieve an equivalent security model? For example, I have 20 logins and want to give them all ...
0
votes
1answer
36 views

Finding keywords in SQL script

I have a list of 50 columns in a database that are likely to change or be removed within the next few months. I have a task to identify any SQL scripts that reference these tables. Up until now, I ...
0
votes
1answer
30 views

SQL Server - Check for opened Activity Monitor

I'm looking for a way to send an alert when a DBA tool is connected for "too long" on a SQL Server Production database. For most of the tools I listed out, I can find the program name with the ...
0
votes
2answers
247 views

Disable SQL Server 2012 Management Studio remote access

I am trying to disable SQL Server 2012 Management Studio remote access from other servers. I have unchecked SQL Server Properties -> Connections -> Allow remote connections to this server. but still ...
7
votes
1answer
521 views

Prevent a stored procedure from being executed outside SSMS

I'm currently working on a stored procedure which modifies metadata for an application. This stored procedure can only be run when the application is offline. I didn't want developers to accidentally ...
0
votes
0answers
191 views

SSMS 2014 installation - Hidden errors in log

I have slipstream installed SSMS 2014 with SP1 + CU2 on my PC (Windows 7 Ent. SP1 with .NET fw 3.5.1 and .NET fw 4) It has a VisualStudio 2010 too. It has a SSMS 2008 R2 installed too. (I know its ...
2
votes
1answer
101 views

Two Databases on same server handle date differently

I have two databases on the same server, one is a backup of the other from a few weeks ago. I have a third party application that has started misbehaving. It logs the LastLoginDate of a particular ...
2
votes
2answers
150 views

Create index with a commentary

I would like to add some comments to my indices. So I added some additional information to the index creation script, expecting to see this comment again as soon as I open the script again. But it was ...
0
votes
0answers
25 views

SSMS: set width for 'New Query' window (using MDI)

Is there a way to prevent SSMS from opening an enormously wide window when I'm using 2 monitors and have SSMS spanning both monitors? I only want the window as wide as a single monitor. Still using ...
1
vote
1answer
1k views

Error message - view server state permission was denied - when connecing 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?
0
votes
1answer
26 views

SSMS 2012 CSV exports

Is there a way to prevent SSMS 2012 from adding the word 'NULL' to CSV exports? Steps to reproduce behavior: Create a new query (Ctrl+N) Select Query | Results To | Results to Grid (Ctrl+D) Run ...
2
votes
2answers
181 views

ssms - how to format T-SQL scripts?

as part of the process to add articles to my publication I use the stored procedure sp_addarticle: use [Returns] exec sp_addarticle @publication = N'USReturns', @article = ...
1
vote
1answer
105 views

Task generated T-SQL shows unknown property IsMemoryOptimized

I have modified a Maintenance plan on SQL Server 2008 using SSMS 2014, particularly Reorganize index task - I have added another two databases for this task. When I wanted to check if the T-SQL is ...
1
vote
2answers
432 views

Format column length in output - SSMS

SQL Server 2012. Sample query at bottom. I'm trying to create a simple report for when a given database was last backed up. When executing the query at bottom with output to text in SSMS, the ...
1
vote
0answers
49 views

SQL Server 2014 Management Studio restore destination changes from selected database

In SQL Server 2014 Management Studio, when I right-click on a database and choose restore, then tell it to restore from a .bak from disk, it always changes the restore destination away from the ...
5
votes
1answer
343 views

Incorrect syntax near 'role' with generated script

I've recently had to recreate a user several times. To facilitate the creation of the user, I would right-click the user and choose script login as, create to, New Query Editor Window. However, after ...
0
votes
1answer
201 views

SQL Server 2012: Users cannot see database properties

I migrated a database from SQL Server 2008 to 2012 and also the users. Now the weird thing is that if the user connects to SSMS on the same server as the SQL Server engine, he can display database ...
-4
votes
1answer
410 views

How do I create multiple users with one login to have access to single database [closed]

What is the benefit of creating a login for users? If a login grants the principal entry into the server, I want to grant this login to three users: db-writer db-reader ddl-admin each with ...
1
vote
1answer
34 views

How do I compare all tables with nonzero rowcounts (in an archive db) with tables of the same name in the line of business db?

(Full Disclosure: I am a software tester who is out of my depth. Because I am unable to get a definitive answer from the developer due to the necessary independence of the test team, I have to figure ...
3
votes
1answer
51 views

Microsoft SQL Server Management Studio - default table view, default table parameters

A friend has recently started teaching me how to design relational databases. Long story short, as I am not SQL-capable yet, we're using SSMS and lots of right-clicking. And I am frustrated with ...
7
votes
2answers
250 views

When running a script with several commands, how to find out where we're at?

I have some processes that require different steps to be taken before they start. For example: Disable check constraint on foreign key: select 'alter table '+fk.table_schema+'.'+fk.table_name +' ...
1
vote
1answer
25 views

restoring SQL Server from backup into a database with different database name?

I have been provided SQL Server backups to restore but they have to be restored into new databases with different names on same server. To explain it, say I have database "MyDB" and its backup ...
7
votes
1answer
173 views

Tab color for registered servers in Management Studio

SSMS allows us to use custom color for each connection. Does anyone know where this information is saved? I'd like to keep the color setup but I keep losing it. edit When I connect from object ...
1
vote
0answers
35 views

SSMS 2012 intellisense is not working on one of the servers?

I dont know if this question is asked - I found similar question - How to enable intellisense, but my case is little different. We have 2 SQL Servers 2012 - one is in the other room, other is in our ...
3
votes
0answers
280 views

SSMS Client Error: Internal connection fatal error

I am running SSMS 11.0.5646.0 on a Windows 7.0 Pro desktop connected by UTP directly to same network switch as my development server (Windows 2008R2 Standard, SQL 2008R2 SE with SP3). All within the ...
4
votes
2answers
190 views

Why would SQL Server remain unresponsive after a slow query completes?

I've just finished debugging a problematic SQL Server 2012 table-valued function. It was declared to use a unique column in the table: CREATE FUNCTION [dbo].[myApp_getUserIdsFromXml] ( ...
0
votes
1answer
27 views

Tools to visualize adhoc multi dimentional data

With SSMS I cannot run a MDX query such as Select [Measures].[Internet Average Sales Amount] on 0, [Product].[Category].children on 1, Product.[Model Name].children on 2 From [Adventure Works]; ...
2
votes
1answer
220 views

Management Studio licensing issues

We have a licensed SQL Server 2012 Standard Edition instance, that for some reason keeps getting license expiration messages in Management Studio. Sometimes it gets this message: Your Microsoft ...
0
votes
0answers
72 views

Error while opening Registered Servers in SQL Server

I just installed SQL Server Management Studio 2012 and I'm trying to open the Registered Server tab to import my xml file with all saved servers, but I'm getting the error described below: "SQL ...