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)

0
votes
1answer
9 views

Why do I not see Configure Distribution when I right-click on replication?

I'm using SSMS 2014 for SQL Server 2008 R2. Why don't I see 'configure distribution' when I right-click on Replication?
1
vote
1answer
23 views

Using SQLCMD with Variables

Im trying to do some general script that i can use to run the same INSERT/UPDATE or DELETE statements on different site databases. This was my first attempt which works just fine, but i have to copy ...
8
votes
3answers
714 views

SSMS Registered Servers with ReadOnly Application Intent

We are working on SQL Server 2014 POC testing with AlwaysOn and one of the user asked about saving the configuration of SSMS with ReadOnly Intent using the registered servers in Local server group. ...
2
votes
0answers
36 views

Can SSMS Object Explorer Details configurations be exported?

A number of employees make use of SQL Server Management Studio (SSMS). I have a configuration file for all new users for Environment (etc) configurations. I want to deliver a uniform view for each ...
4
votes
0answers
22 views

In SSMS, is “Navigate to” (Ctrl+,) of any use?

In standard Visual Studio 2012 or higher, IDE window called Navigate to... (Ctrl+,) offers all useful objects in scope of currently open project (see samples) getting increasingly filtered as I am ...
0
votes
1answer
137 views

Maintaining multiple build versions of asp .net / SQL Server applications

We have new versions of .net applications deployed every week for testing given in form of new build files. Can any one suggest how I can maintain many versions of the builds without having to keep ...
12
votes
11answers
14k views

Sql Server Management Studio slow opening new windows

After upgrading both sql server and management studio from 2008 to 2012, the management studio 2012 is very slow when new query windows and dialog boxes are opened. Even right click on tables is slow. ...
1
vote
2answers
3k views

SQL Server Express 2014 Installation directory

I face recently a problem when starting SQL Server Management Studio. As it can't start, I uninstall it. When trying to install it again, I am asked to select the installation folder of SQL Server. ...
4
votes
1answer
122 views

how to ignore the SSMS (sql server management studio) sql server ansi settings?

The options in Management Studio On Management studio Tools->Options->Query Execution->SQL Server there are options that are set and these prevail over the same options that are set on database ...
4
votes
2answers
366 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 ...
3
votes
1answer
46 views

How does SSMS get a list of files in a backup?

When restoring a database that has multiple files, SSMS gives you the option to restore as other paths and file names. How does it retrieve the list of files from the backup? Can I do that in a SQL ...
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 ...
1
vote
1answer
20 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" ...
2
votes
2answers
33 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 ...
2
votes
0answers
185 views

Change version number of maintenance plan package

We have a Maintenance Plan on SQL 2012 that has been running fine. I made a change to it yesterday using SSMS 2014. When the plan ran last night I got the following error: The version number in ...
3
votes
2answers
150 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
668 views

SQL Server 2008 R2 Database Diagram Error Code

I have sysadmin privileges on a SQL Server 2008 R2 server. I'm working with the development database and want to save a database diagram I created. When I try to save I get the following error ...
2
votes
1answer
398 views

SSMS IntelliSense doesn't work on particular database

I have SSMS 2014 installed on my desktop, and many 2012 and 2014 databases running in our data center. So far I found one database (database A) doesn't have IntelliSense working, for exampletyping: ...
-1
votes
2answers
95 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: ...
-1
votes
1answer
23 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
0answers
431 views

Full-Text Index menu option not appearing in SQL Server Management Studio AND error when right clicking a table

I am using SQL Server Management Studio Version 11.0.3128.0 and SQL Server 2014 12.0.2361 Web Edition. I have successfully created a Full Text Catalog following these instructions: Cannot use a ...
0
votes
1answer
845 views

How to query a server linked via ODBC

I've looked at multiple other questions about querying linked servers, but nothing has worked for my setup. Notes: I'm not using localdb at all. I just wanted to use SQLSMS for a remote cache ...
2
votes
1answer
432 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
65 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 ...
0
votes
1answer
71 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) ...
2
votes
1answer
14 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
1answer
772 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?
3
votes
1answer
2k views

Inline edit SQL Server database rows from Visual Studio

I'm pretty sure Microsoft have pulled one of the most useful features for performing quick edits on a SQL Server Database within the Visual Studio IDE. It seems to have only affected SQL 2012 ...
3
votes
1answer
70 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
0answers
63 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 ...
1
vote
0answers
2k views

SQL Server does not exist or access denied" after installing SSMS

I recently installed SQL Server Management Studio (which also installed SQL Server 2016 to my local machine), and now am unable to connect to SQL Server from applications on my machine. It will come ...
0
votes
1answer
19 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 ...
5
votes
2answers
2k views

Connecting from SSMS to an EC2 SQL Instance

I have an EC2 server running SQL2008 R2. I opened the port 1433 and successfully tested with yougetsignal.com/tools/open-ports. I have set the SQL Server to Accept Remote Connections. I have set ...
1
vote
1answer
43 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 ...
2
votes
3answers
8k views

SQL Server 2012 - Insufficient memory to continue the execution of the program. (mscorlib)

I have a sql file, which is up to 180 Mb. When I try to open and execute it on Microsoft SQL Server Managment Studio 2012, I am getting this error. . What do do ? I researched on Google. And there ...
5
votes
2answers
603 views

Why does SQL Server Management Studio crash?

When I open SSMS I get this message: SSMS - SQL Server Management Studio has encountered a problem and needs to close. We are sorry for the inconvenience. What can I do? The issue persists ...
6
votes
1answer
331 views

Login failure error log when querying Central Management Server group

I am querying a group under a Central Management Server, which results in the following being logged to the SQL Server Error Log. Error: 18456, Severity: 14, State: 38. Login failed for user ...
6
votes
3answers
10k views

How to map another server through SQL Server Management Studio

I am trying to map another server by giving the command EXEC xp_cmdshell 'NET USE H:\\568.256.8.358\backup_147 1234abc /USER:cranew /PERSISTENT:yes' I got an error with this: network path ...
1
vote
1answer
49 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' = ...
1
vote
3answers
8k views

How do I modify the user interface language in SSMS?

How do I modify the user interface language in SQL Server Management Studio? For instance, if I installed in English, but wish to view in Japanese (to name but one possible example). I am running ...
6
votes
3answers
1k views

SQL Server Management Studio 2014 Backup - Set Property Devices Error

I recently upgraded my local SQL Server to Version 2014, which also installed the SSMS 2014. When using SQL Server Management Studio 2014 to create a backup (both local and remote, Server Versions ...
-2
votes
1answer
44 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 ...
2
votes
1answer
245 views

my azure sql database is not connecting with SSMS 2014

The firewall contain my IP in valid list but I am still getting error in connection. I tried the command C:\Users\MianAsbat>SQLCMD -U username -P password -S and got the following response. I ...
1
vote
1answer
51 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
57 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
44 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
votes
1answer
342 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 ...
1
vote
1answer
84 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
0answers
32 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
95 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 ...