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)

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
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 ...
1
vote
2answers
233 views

Cant connect to Server using SSMS on my desktop

SQL SERVER 2008 R2 When attempting to connect to the default instance of sqlserver on our local server from SSMS on my desktop I'm receiving the following error. A network-related or ...
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 ...
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 ...
0
votes
1answer
1k views

Missing Database Mail Configuration Wizard in SQL Server 2008 R2

I was able to verify that Database Mail is installed and running but when I expand the management folder there is no Database Mail Configuration Wizard.
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 ...
0
votes
2answers
85 views

Cannot connect in SSMS with Windows Authentication

I found and added the server name through <Browse for more...> -> Network Servers so it exists and is correct. What seems weird is that the Password field is empty and I cannot modify ...
-1
votes
1answer
3k views

Unable to attach mdf file on SQL Server 2014

I have SQL Server 2014 on my Windows 8.1 Pro machine. However, I couldn't find any sample database for 2014 version and hence I am trying to attach AdventureWorks2012_Data.mdf file by right clicking ...
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 ...
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 ...
2
votes
1answer
1k views

Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012

I have two local SQL Server instances running on my local machine. The first is SQL Server 2008 R2 Enterprise Edition (named MSSQLSERVER) and the 2nd is SQL Server 2012 Business Intelligence Edition. ...
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 ...
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]; ...
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] ( ...
1
vote
0answers
1k views

how can I track down the source of “Internal connection fatal error”?

I'm working on a 6-700 line SQL script today. I'm running it from SSMS. Pointing at a SQL 11.0 db. About half the time I run it, I get: An error occurred while executing batch. Error message is: ...
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 ...
1
vote
3answers
266 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 ...
2
votes
1answer
52 views

remove maintenance plan

I have the following error while trying to delete some old Miantenance plans on the MS-SQL server: Please help.
1
vote
0answers
726 views

Change Root Directory on server properties page in SQL Server 2014 SSMS

We did in inplace upgrade from SQL 2012 to SQL 2014 (I know it wasn't the best choice, and it won't happen again, so no need to beat that horse). I have both the MSSQL11.MSSQLSERVER and ...
1
vote
1answer
69 views

Show the error message, after I accidentally clicked “Yes” on “don't show error again”

I was trying to alter an existing Maintenance Plan, but received an error on doing so. Before actually reading it I clicked it away, too late realizing that the text said "Do you wish to hide this ...
1
vote
0answers
197 views

Is there any way to set the default data source for the SQL Server Import and Export Wizard?

When I launch the SQL Server Import and Export Wizard for SQL Server 2014, the selection in the Data source drop-down defaults to .Net Framework Data Provider for ODBC. This happens regardless of ...
1
vote
3answers
726 views

SSMS 2014 working with SQL Server 2005 instances

Is there any major complication that one could run into while using the latest (developer) version of SSMS with older SQL Server 2005 instances? Any way one could affect the data by using this ...
1
vote
1answer
81 views

SQL Server 2008 R2 copy Schema with all user security permissions

I have a prod support request from a high value user to adjust the settings on a company-wide dashboard so that he can manage a section of his workflow currently being excluded from these reports. ...
1
vote
1answer
48 views

SMSS will start for one user, but not another?

We have a SQL Server 2012 and SMSS 2012 installed. The C:\ recently ran out of space due to a misconfiguration, and now we have 1 user who cannot start SMSS they receive the error: "Cannot find one ...
0
votes
0answers
58 views

Send trigger email when someone connects to a database

How do I set up a trigger or alert so that when anyone connects to a specific database, an email will get send with that user's login credentials?
0
votes
0answers
52 views

SMO Not Scripting DB Objects

I have a PowerShell function included in the allusersallhost profile. It is basically scripting linked servers. When I execute the function from a PowerShell session, it scripts the linked server ...
3
votes
1answer
84 views

SSMS 2012 mutiple query windows using same session

I wonder if it is possible to connect multiple files or query windows in SSMS to one session? The reason is that I want to use local temporary tables that are created in one file/query-window in other ...
4
votes
1answer
42 views

Configure SSMS intellisense / web browser settings to accept UNC directory path inputs

I would like to navigate to open a directory path from an in-line commented UNC path. SSMS integrates with Windows Explorer and Explorer allows UNC navigation from the address bar. Indeed, when in ...
0
votes
1answer
921 views

SQL Server Management Studio backup not shown when restoring

I am trying to restore a database from a backup taken on another server. I am doing this by using SQL Server 2012 Management Studio. After I have taken the backup on server 1, I go on to select the ...
1
vote
1answer
429 views

Missing diagram option SSMS

I would like to create a relationship between to tables. Normally and in previous versions of sql server and the management studio I would go to database diagrams and draw the relation in the diagram. ...
1
vote
1answer
17k views

How to downgrade my mdf file from version 661 to 655 or earlier?

I have a problem when attaching the file AdverntureWorksLT2008R2_Data.mdf to Microsoft SQL Server Management Studio (SSMS). The database 'AdventureWorksLT2008R2' cannot be opened because it is ...
3
votes
0answers
874 views

General access denied error while using import data in SSMS [closed]

I am using SQL Server Management Studio with the following version information below: Microsoft SQL Server Management Studio 10.50.4000.0 Microsoft Data Access Components (MDAC) ...
2
votes
2answers
216 views

Drop and Create Script not working

I'm fairly new to databases, but I'm beating my against the wall trying to do something that (I believe) should be fairly trivial. I'm using SQL Server Management Studio 2012 and am trying to delete ...
4
votes
1answer
298 views

Why does SSMS highlight SUBSTRING in purple but RIGHT in grey?

I apologise for the trivial question, but I was trying to work out how to do a RIGHT in SQL so I experimentally typed RIGHT and it didn't highlight in purple, so I spent some time scratching my head ...
3
votes
1answer
250 views

Microsoft Help Viewer in ssms 2014 doesn't open local documentation

I have Visual Studio 2013 installed I have downloaded all documentation I need installed via visual studio. I can open it with the command "C:\Program Files (x86)\Microsoft Help ...
3
votes
0answers
86 views

SQL Job Step created via wizard does not correctly set server & database_name values

I've recently been tasked with migrating a database from SQL Server 2005 to 2008R2. This has all been accomplished without any issues, but one part of the system requires a Snapshot Replication to be ...
7
votes
5answers
8k 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 ...
0
votes
2answers
101 views

SSMS fail to connect localhost SQL Server 2008 R2 suddenly [closed]

Until today when accessed by remote desktop to my sql server could connect using localhost, but suddenly I cant (without any update or change in my server), now I can connect using localhost\instance ...
2
votes
1answer
42 views

Local SSMS client is not connecting one particular server

My SSMS is not connecting to one particular server say X except X it is connecting to all the other servers. Could not find the root cause for this problem do any one have idea here? Guy sitting next ...
1
vote
2answers
42 views

Custom ORDER BY

Are there other ways to use ORDER on my results? 20150507094958A DISPOSED 2015-05-07 09:50:00.853 Samuel MONEY 20150507094958A DISPOSED 2015-05-22 09:25:00.000 Jeff AUTOMOBILES ...
1
vote
1answer
752 views

How to do a SELECT inside of a PIVOT [duplicate]

I am trying to SELECT values from a column in my database in order to perform a PIVOT on those values without hard-coding them. SELECT * FROM (SELECT ItemType, [Status] FROM ...
2
votes
1answer
1k views

Missing Index Not Displaying In Execution Plan

I recently installed SQL Server Management Studio 2014 (Developer Edition), and I noticed that I am no longer seeing the missing index feature. What I have done: Ran the workload through Database ...
1
vote
0answers
94 views

Using :Connect I keep getting msg 911 - database [dbname] does not exist

I have a two part T-SQL script, the first part runs against a database on a different server, the second part is supposed to run on the local PC. I'm using SQLCMD mode and the :Connect keyword but ...
5
votes
1answer
159 views

Exporting SQL Server DB from my laptop to AWS RDS

I am following this tutorial from AWS to export a SQL Server database that currently sits on my laptop to Amazon Web Services RDS. In particular I am trying the Generate and Publish script wizard ...
3
votes
1answer
26 views

Information about a column and the data it holds?

I'm working with a table that has 3 different dates associated with each item in the table. I don't understand what each time is so I want to know if there's a standard place that the person who made ...