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
0answers
5 views

INSERT INTO MSSQL Linked Server without specifying database in semi-fully qualified name

I have a Server called DEV, a database called Nus12345, a linked server called SnapshotDev, a schema called Snapshot, and a table called SnapshotPersonEmployee. On the DEV server, there are many ...
0
votes
0answers
43 views

Why can't a user in a group with the sysadmin role see any stored procs in SSMS?

A developer who is in a "Developers" group granted the server fixed role "sysadmin" on the development SQL Server installation is unable to see any stored procedures in a database - only the "System ...
1
vote
3answers
58 views

How can I hide a column using a Select statement?

declare @bid varchar(4) = '1007' select sr.release_date, sr.customer_id, sr.customer_name, sr.item_id, sr.item_desc, sr.order_no, sr.qty_on_hand, sr.release_qty, ...
1
vote
1answer
57 views

SQL Server TempDB size issue

SQL Server reported that our tempdb is out of space. So I had a quick google search and found this on technet https://technet.microsoft.com/en-us/library/ms176029(v=sql.105).aspx Determining the ...
1
vote
0answers
27 views

SQL Replication Monitor does NOT show publication properties - Transactional Replication

The setup I have is as follows: a) Version SQL Server 2014 SP1 CU6. b) publication is on a separate availability group [AG1] and subscriber is part of another AG [AG2]. c) Distribution is ...
0
votes
1answer
25 views

SQL Server Management Studio - Processor counters for different sessions do not add up

In SQL Server Management Studio, I have two sessions. The workload for each session is: Session 1: while loop to select top items from one table; Session 2: while loop to update statistics of ...
1
vote
1answer
38 views

Why does SQL Server Mangement Studio not script Indexes by default?

Recently I realized by default, scripting the database does not including indexes, and I have to change the option every time. Could anyone please explain the reason? Is there any insight about this ...
1
vote
1answer
22 views

Managing SQL Server logins and database users

I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question about server logins and ...
1
vote
2answers
55 views

Log in as another SQL Server user via SSMS to check their permissions?

I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question: Once I have given a set of ...
0
votes
1answer
29 views

Visual Studio 2010 Shell Error - is it Causing this SQL Server error?

Visual Studio 2010 Isolated Shell has the infamous "Invalid License Data. Reinstall" error. I have SSMS 2014. I have tried reinstalling several times, I installed Visual Studio 2013 but SSMS doesn't ...
0
votes
0answers
17 views

SQL Server Policy Management Escaping for LIKE/NOT LIKE conditions

I would like to post this question and answer it right away in case anyone else has wondered... After hours of research and even opening this issue http://connect.microsoft.com/SQLServer/feedback/...
0
votes
1answer
43 views

SQL Server 2012 Reconnects each time I run a query

I use SSMS 2012 and each time i run a query especially the right click select top 1000 rows the database has to reconnect. I am not required to input a user and password but it is frustrating having ...
0
votes
0answers
26 views

Run SQL Agent Jobs in Sequence

While there are other questions out there in forums, I notice that those are several years old, and I hope that things have changed by now. I am using SQL Server Management Studio 2014 and I have to ...
0
votes
0answers
9 views

Clients filtered views are empty

I am trying to access the data in one of our clients databases. I got a backup file from them and opened it in SSMS. There is data in their tables but I can't find any in their views which I need to ...
1
vote
0answers
28 views

connection closes unexpectedly with different kind of errors

When I execute a query which returns more than 300 rows I’m getting random errors and the connection closes for example An error occurred while executing batch. Error message is: SqlDateTime ...
2
votes
0answers
47 views

SQL Agent parsing actually executes instead of just validating

I'm seeing some really odd behavior with SSMS 2014/2016 that I stumbled accross by pure accident. This was run on SQL2014 SP1+CU6 (the fixed one) in a non-prod environment. Here's the backstory. I ...
1
vote
1answer
49 views

Howto avoid textdata of trace gets truncated?

I have a trace file including the TEXTDATA column created by a server-side tracing. Some of the traced queries are very long. If I re-open the trace file on Profiler, the relevant long query is ...
2
votes
0answers
83 views

How do you install a TFS plugin for SQL Server 2016 Management Studio?

How do you install a TFS plugin for SQL Server 2016 Management Studio? The source control option is no longer in the option list so the existing workarounds no longer appear to work.
4
votes
1answer
57 views

Why are duplicate permissions appearing on the securables GUI in SSMS?

Why are duplicate permissions appearing on the Securables GUI?
1
vote
0answers
14 views

SSMS Crashes when attempting to restore DB from Azure URL

I'd previously been using the April 2016 version of SQL Server Management Studio with no issues, but have run into problems since updating to the GA June 2016 version of SSMS. When I try to restore a ...
-1
votes
0answers
90 views

Management Studio 2016 “list member” (IntelliSense) not working?

I installed the newly released SQL Server Management Studio 2016. My database servers are still 2014. However, the "list member" feature doesn't work. I've checked all the possible settings in the ...
0
votes
1answer
26 views

How to display User Mapping for offline databases?

When I use the GUI (SSMS) to review the User Mapping, where the Login has mapping to a database that is offline (or otherwise not available) I get the message below and it only displays Mapping for ...
1
vote
1answer
17 views

append 0 returned by DATENAME function Sql Server management studio

I want to append 0 to my minute(mi) result returned by DATENAME function of sql server management studio. select datename(mi,GETDATE()) If the current time where 12:06:33.12(hh:mi:ss) then '6' ...
0
votes
1answer
42 views

How to delete duplicate records in my database? [duplicate]

I joined about 12 databases into 1 db and in each database I have some duplicate records. How can I delete all duplicate records in my joined database? For example, I want to delete duplicate ...
0
votes
0answers
39 views

SSMS Error - Parameter is not valid

I have both SQL server 2005 and SQL server 2008 management studio installed on a windows server 2003 32 Bit. My issues is that both the SSMS opens fine but i face this below error messages when i ...
1
vote
1answer
42 views

Wingdings font in SSMS's column

I do want to create a column which should has check marks and cross marks. Here is the part of my query: iif(order_details.order_status = 'Y',char(252),char(251)) as [completed?] After I execute ...
0
votes
0answers
40 views

Export query execution settings from Management Studio

Actually, we're migrating from SQL Server 2000 to SQL Server 2014 (approximately 300 servers. With SQL Server Enterprise Manager 2000 and SQL Query Analyzer, we can export some settings (Connections ...
0
votes
0answers
12 views

My company changed windows domains and now I cannot access SQL Server Management Studio

I'm able to connect to the object but cannot access the databases (except for master) and cannot change permissions. This is just a local instance and I have backups of the data so I'm not concerned ...
1
vote
1answer
31 views

Microsoft sql server management studio (SSMS) shortcut for changing size of sql/result panes

In the good old days there was a shortcut ctrl-B for changing the size of the Query & Result panes in the Query Analyzer sql editor. In Query Analyzer, just press ctrl-B and the screen splitter ...
2
votes
1answer
56 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 ...
1
vote
0answers
47 views

SQL Server Management Studio creates 18456 login error using registered server group

I have been using "Local Server Groups" registration for quite a while now with SQL Server 2008 Management Studio. I have created a group with 5 registered servers. They are registered using SQL ...
0
votes
0answers
43 views

Not able to see systemViews

I recently installed SQL Server 2016 RC3 and latest version of SSMS (April 2016 preview). Today I subscribed to Azure S0 database. When I tried to check system views in Azure and in my local database, ...
0
votes
1answer
44 views

extract values from different stored procedures and create one report

At the company I work, the third party taking care of the database. So there is giant complex stored procedure that produces the result for one parameter only. When management needs a desirable ...
0
votes
1answer
21 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?
2
votes
1answer
38 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 ...
6
votes
1answer
56 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 ...
3
votes
1answer
64 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
1answer
146 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 level....
3
votes
1answer
47 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 ...
4
votes
2answers
380 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
156 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
60 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
53 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
17 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
103 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
226 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
86 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 ...