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
12 views

Can SSMS or SSDT validate and insert security objects?

Can Sql Server Management Studio validate and insert security objects (roles, schemas, asymmetric keys, certificates, users, and so on) both at the server and DB level?
0
votes
1answer
1k 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 ...
1
vote
2answers
26 views

SSMS clean output window with sql instruction

How can i clean output window in SSMS using t-sql syntax? Is it possible ? Do you know any workarounds ?
0
votes
0answers
35 views

SSMS 2016 Maintenance Plan Designer Perms

We have some older maintenance plans that were built with SSMS 2014 on a Sql Server 2014 instance. The connection defined for the plan uses a Sql Server account with sysadmin perms. When you edit ...
1
vote
1answer
49 views

Matching empty string is not working

I have the following query SELECT Ice.IceId, Ice.Code, Box.Ice, LEN(Box.Ice) AS IceCharLength, DATALENGTH(Box.Ice) AS DataLength, Box.Ice, ASCII(Box.Ice) AS ASCII, CAST(Box.ice AS ...
3
votes
3answers
20k views

SQL Server 2008 R2 Management Studio : “Evaluation period has expired”

I've spent several hours trying to fix this issue so far with no success. I had installed SQL Server 2008 Evaluation Edition. Out of fear it might expire & create problems for me I installed SQL ...
1
vote
1answer
234 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. ...
12
votes
13answers
15k 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
1answer
12 views

Prevent SSMS changing tab to space when copying text from Result Tab

SSMS 2016 changing tabs to spaces when copying from Result Tab (does not matter ctrl+c or drag&drop). For example if execute this code SELECT 'a' + CHAR(9) + 'b' then copy text from result tab ...
15
votes
3answers
1k views

Was Management Studio removed from SQL Server 2016 installation media?

I just tried installing SQL Server 2016 Enterprise but I noticed that Management Studio was not installed by default. I also noticed there is a separate link to SSMS in the installation guide which ...
3
votes
2answers
2k views

Error message - view server state permission was denied - when connecting 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
40 views

“CREATE FILE encountered operating system error 32” when attempting to attach database

I am having trouble connecting to a database I created in SSMS. Keep in mind this is my first time working with databases. All I've done in this database is create some tables and add a few records. ...
3
votes
2answers
2k views

What does Reinitialize All Subscriptions actually do to the databases

I tried to find the answer and came across these MSDN pages but they don't actually explain what happens really: http://msdn.microsoft.com/en-us/library/ms152771.aspx http://msdn.microsoft.com/en-us/...
0
votes
1answer
152 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 ...
-1
votes
0answers
25 views

SSMS Script Create Options not working correctly

I am using SQL Server Management Studio 2014. When I right click any Stored procedures and select eight "Drop and Create to" or "Create To" option it always create an alter script. I Don't Know ...
2
votes
1answer
63 views

SQL Server Management Studio 2016

It's a strange problem with my SSMS 2016. With in the query window backspace, del, up, down, left, right keys nothing works. But when I reset my environment settings with "Import and Export Settings" ...
3
votes
3answers
8k views

SQL Server Management Studio generates error, can't start

On my development machine, SQL server 2008 R2 was running fine previously. But after formatting OS and re-installing the OS and SQL server, it generates the following error when I want to start SQL ...
2
votes
4answers
7k views

Cannot find one or more components. Please reinstall the application

I am getting this error in Windows Server 2012 with Visual Studio 2012 installed trying to open SQL Server Management Studio 2012: Cannot find one or more components. Please reinstall the ...
3
votes
1answer
23 views

How do I uninstall only SSMS and Profiler for 2008R2?

I'm running SQL Server 2008R2 locally on my dev workstation, and I use SSMS and Profiler quite often. I recently installed the July 2016 version of those tools, and I'd like to remove the 2008R2 ...
1
vote
1answer
1k views

Printing comments or statements when executing script to a output file using TOAD/ORACLE

Coming from a SQL SSMS environment, I would like to duplicate their Print Command which allows you to print commands or variables while executing a query. I am looking for this feature to help ...
9
votes
4answers
979 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. ...
0
votes
0answers
56 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 ...
0
votes
1answer
35 views

INSERT INTO SQL Server : 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 ...
1
vote
3answers
69 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, ...
2
votes
2answers
707 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 message:...
1
vote
1answer
160 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 ...
1
vote
1answer
61 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 ...
5
votes
2answers
5k views

SQL Server 2012 is putting [brackets] around Table and Column Names

Is there anyway to turn that off? I'm unable to find anything in options, and they're really a distraction.
1
vote
0answers
33 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
26 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 ...
0
votes
1answer
37 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 ...
1
vote
1answer
40 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
24 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
59 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
44 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 ...
2
votes
1answer
524 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 ...
0
votes
0answers
20 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/...
6
votes
1answer
61 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 ...
10
votes
6answers
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
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
10 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 ...
3
votes
3answers
9k views

Greyed out menu options, broken activity monitor

I recently installed SP1 on my 2012 SQL Server. Ever since then SSMS has behaved a little weirdly when I connect from my pc rather than from the local server itself. I no longer see the green "...
1
vote
0answers
32 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
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 ...
2
votes
0answers
52 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
62 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 ...
4
votes
1answer
64 views
8
votes
1answer
70k views

Find all the queries executed recently on a database

[I am a beginner level T-SQL Programmer] [..and hopefully I am on the right stack exchange site] I would like to get a list of all the queries I executed (in the least, those I executed today since ...
3
votes
0answers
164 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.
1
vote
0answers
21 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 ...