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)

4
votes
2answers
392 views

Help undoing an accidental restore on SQL Server 2014

Yesterday I made a serious mistake¹: Restoring the wrong database. Background (you may skip this section): I right-clicked the Test database and proceeded to the "Restore Database" section as ...
1
vote
1answer
24 views

Is it possible to attach a description field to the records in INFORMATION_SCHEMA.TABLES?

In SQL Server, [database name].INFORMATION_SCHEMA.TABLES has the following columns: TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE This table has no additional fields, such as "DESCRIPTION" ...
0
votes
1answer
45 views

Pull the latest Employee and Manager Comments Based on Modified date

I have a table Comments which is linked to the Plan table. Each time the user adds a comment on a specific plan, the Comments table is populated. This table stores the historical data. I need to pull ...
3
votes
2answers
158 views

Does SSMS follow the same support lifecycle as SQL Server?

I've found information about the support lifecycle for SQL Server (such as this page for SQL Server 2008/2008R2), but haven't found any information about SSMS. Does SSMS follow the same support ...
2
votes
2answers
73 views

Cannot see new drive in SSMS maintenance wizard

I'm trying to setup a Backup Maintenance Plan in SSMS for Sql Server 2012, running in a failover cluster on Windows Server 2012. The current plan backs up to the same cluster volume where the ...
-1
votes
1answer
81 views

Microsoft SQL Server Not Showing Server Name in object Explorer [duplicate]

I Recently Installed Microsoft SQL Server 2014 (SSMS) on my local machine for development learning purposes. I am running Windows 10 32 bit. When i try to connect, Server Name does not appear. Screen ...
2
votes
1answer
20 views

What are valid connection strings for SSMS login box?

What are valid connection strings for SSMS login box? Every once in a while I will have to connect to an instance of SQL Server with some specific configuration setting or in a DMZ where no host ...
0
votes
0answers
126 views

Database Recovery Pending

Today I opened Sql Server Management Studio, after logging in as normal one of the DB is marked (Recovery Pending). I tried to recover with the backup file - seemed to work, but would fail as poss ...
0
votes
1answer
298 views

SQL Server 2016 Plugin's not working [closed]

Recently I installed SQL Server 2016 on my PC. Here is the detailed information of my server : Microsoft SQL Server 2016 (RC1) - 13.0.1200.242 (X64) Mar 10 2016 16:49:45 Copyright (c) ...
3
votes
1answer
102 views

Don't see it : Integration Services Catalog, and open the [All Executions] report

I have SQL Server 2012 Enterprise Edition (64-bit) on Windows NT 6.2. I am not seeing the option to the "[All Executions] report" in the Integration Services Catalog . How can I solve it? Update: I ...
0
votes
1answer
21 views

What versions of SSMS have an Express edition?

I know all the SQL Server versions from 2005 to 2014 have an express edition. This question is specifically about SSMS. There was an SSMS Express 2005, 2008, and 2008 R2, but I haven't found any later ...
2
votes
2answers
102 views

SSMS for 2008r2 job activity monitor works…SSMS for 2016 rc1 error message

Wanting to use the latest and greatest, I downloaded the SSMS 2016 rc1 (and have downloaded the previous previews, liking what I see) and I have a situation that is similar to How to resolve error &...
1
vote
1answer
60 views

Can we move SQL Server installed bit from default location to other drive

My client gave me command line installer for SQL Server. Since it is command line there is no option to select the installation path! So installer automatically chooses the default location C:\Program ...
1
vote
1answer
127 views

Start failed for Job in SQL Server Agent

I am trying to schedule a job which executes stored procedure but it is failing. DECLARE @return_value int EXEC @return_value = [dbo].[sp_WarehouseAttendance_New] SELECT 'Return Value' = @...
-2
votes
1answer
65 views

Cannot update nor insert data to datetime field [closed]

I was trying to insert data through one web application I am developing and I could not insert data, while I was troubleshooting what the problem is, I saw that I can not neither edit datetime field ...
1
vote
1answer
76 views

Hide Schemas and Tables

I have the following structure: Views dbo.vSales Sec.vSales Tables dbo.Security Sec.Products Sec.Countries Sec.Users I have 2 groups accessing my Database: Administrators Standard_User ...
1
vote
1answer
47 views

Cannot Start/Stop Services using SSMS 2014 (but 2008R2 works)

In SSMS 2014, when I connect to a server in Object Explorer using my network credentials (I am a domain admin), I can do pretty much everything I would expect as a DBA. But I cannot start/stop/restart ...
1
vote
1answer
89 views

SSMS connects, Linked server fails

There's a SQL Server 2012 machine which I have login and password. It's a SQL Server login, not an AD one. I'm able to login using SSMS. But when I configure a linked server in my SQL Server I get ...
1
vote
1answer
165 views

How to backup SQL Server database once evaluation period has expired

I'm using Microsoft SQL Server Management Studio from last one month that is evaluation period software. I'm not able to login in management studio. when I enter my user name and password it gives the ...
0
votes
1answer
77 views

Restore Database Wizard not launching

I'm using SQL Server Management Studio 2012 and trying to use the 'Restore' functionality to copy an existing database into a new one. This is something I've done a dozen times before, but I'm ...
1
vote
1answer
132 views

SQL Server Management Studio: The columns in table do not match an existing primary key or unique constraint

I have two tables: Students and Courses. I want to set a foreign key in the Students table from the couseId column to the courseId column in the Courses table. I have set primary keys to both ...
2
votes
1answer
67 views

SSMS: possible to script 'file per object' into categorised folders like in object explorer?

e.g. if you run the 'generate scripts' function (by right clicking on a db in object explorer) to script out an entire database, it creates all the files in one folder and annoyingly names them as [...
0
votes
0answers
56 views

Untrusted domain error connecting to another group in workgroup SQL Server 2014

I have two computers connected in a workgroup that are sharing files and folders. When I try to access the SQL Server of the other computer I get the same error from both. Login failed. The ...
1
vote
1answer
229 views

Maintenance Plan Wizard generates invalid script?

I've used the Maintenance Plan Wizard to create a plan. When I execute the plan, the "Maintenance Cleaup Task" fails with this error message: Executing the query "EXECUTE master.dbo.xp_delete_file ...
0
votes
0answers
50 views

Import view definition from Oracle to SQL Server using SSMS data import wizard

As the title says, I'm looking to import the create script from an Oracle view in order to recreate it in SQL Server. I can only access the Oracle database through the SSMS data import wizard. These ...
1
vote
2answers
42 views

Use connection string to connect to Azure database from SSMS?

I have a connection string for an Azure database. I'm hoping there is a place in SSMS where I can plop in that string and connect to it. Alternatively, if there is a way to do it with a T-SQL query, ...
8
votes
3answers
210 views

Is it possible to disable the remember password checkbox in SSMS?

Some time we are providing same laptop for 4-5 employees in our office for some testing purpose (since a costly licensed tool is exist in that laptop only), also asked them to do not click the ...
3
votes
1answer
72 views

Why does SQL Server need permissions to access data and log files?

When you want to attach a database, you can open them up if you put those mdf files in a folder such as: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ But SQL Server will ...
4
votes
3answers
379 views

Why does server name need to be specified when accessing local instances?

Even though I have direct access to the physical database machine, I have to specify dbmachine\sql in the connection field, rather than just the instance name. Why is that?
0
votes
0answers
55 views

SQL Server 2008 R2: Could not connect to TCP error code 10061

I am having the problem that I'm simply not able to connect to a running SQL Server using Microsoft SQL Server Management Studio. Every time I try to connect to the server I am getting: Could ...
3
votes
1answer
133 views

SSMS: Import from flat file (.csv)

In SQL Server Management Studio (SSMS) 2008 R2, I wish to import a not-quite-properly formatted CSV into a database table. I was trying to use the wizard at <database name>->Tasks->Import Data. ...
0
votes
0answers
17 views

Connecting database ISSUE to remote database in mssql [duplicate]

May be This question seems repeated but please read whole question carefully. I have Microsoft SQL Sever in one PC (ex. machine A) and I wants to connect and get data from that database from another ...
3
votes
0answers
47 views

How to deal with Users Needing to Enter Mixed Data Types in MS SQL Server

I have a form in a C# application that I can't change with a data table bound to a query. The user enters a mark for a student's task or 'A' for absent. However, the person who designed this had the ...
-1
votes
1answer
69 views

How can you allow only the database owner and system administrator to use a database? [closed]

I am on SQL Server Management Studio 2014. I need to allow me, the database owner and the system administrator to use a database. Also, can both users use the database at the same time?
-1
votes
2answers
200 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
714 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
30 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
84 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
53 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
726 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
32 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
67 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
243 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
27 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
296 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
820 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.
14
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 dbo....
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
142 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 ...