Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ssms]

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.

0
votes
1answer
13 views

SQL SERVER Checking for Compatibility of the Database File Locations on the Server Instance that Hosts Secondary Replica

I am using SQL Server 2017 and SSMS 18.0 Version. During creation of availability group at validation step at primary Server (DBN1), i am facing that error i.e. the following required directories do ...
0
votes
2answers
27 views

ssms does not let me change to server authentication mode and I can not log in

I have been using SSMS and logging in through server authentication for a week now and yesterday when I tried to login it suddenly told me "no process on the other end of the pipe". I researched ...
3
votes
1answer
122 views

best way to run sql server management studio on linux

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker. I want to use sql server management studio to manage the server. SO far now, I have a windows 7 enterprise with with ...
0
votes
0answers
17 views

Unable to add unit tests in Visual Studio or SQL Server Management Studio

I've been looking at Microsoft's official docs and other websites (including this one) and am unable to create unit tests for stored procedures following their instructions. The things I've read say ...
2
votes
0answers
51 views

How to prevent SQL files opening new instances of SSMS 17.9.1?

Synopsis This is not a new problem and there are several solutions floating around on Internet. Problem When you double click on a .sql file, a new instance of SSMS is opened. I did not have this ...
0
votes
1answer
36 views

Setup Multiple SQL Server Tree Structure similar as RDC based on Enviornments

I want to setup multiple SQL Servers like a tree structure similar to Remote Desktop connection Manager, where we can setup multiple servers based on environments we support like Test and Prod.
0
votes
0answers
36 views

Loading 'Image Service Package' crashes Management Studio

I'm getting the following error on my SQL Server when I log into the system: I ran a repair on SSMS successfully, but it did not resolve the issue. The following error message is recorded in Event ...
0
votes
1answer
45 views

MSSQL Instance Alias - how does it work

Ok I'm trying to understand how a MSSQL Alias works but documentation is lacking to say the best. Most blogs/videos/documents I can find state that all you need to do is go to SQL Server ...
1
vote
1answer
45 views

sql server data classification

I am working on a data governance enhancement at my work. My current task is to use ssms classify data feature. However, I want to customize the "sensitivity level" for my work (government) we have ...
0
votes
0answers
60 views

Issues with a SQL Server instance alias

I have the most simple of questions: I've got a Microsoft SQL Server with two instances, default and a named instance called Instance1. The default instance is running on static TCP/IP port 1433 and ...
2
votes
0answers
44 views

Disable or Remove Edit top 200 Rows option from SSMS

I have already done some R&D on the same but don't have the real solution. Is there a way to obsolete the right click option "Edit Top 200 Rows" from SSMS? The goal is to prevent developers from ...
19
votes
1answer
1k views

Why does a simple loop result in ASYNC_NETWORK_IO waits?

The following T-SQL takes about 25 seconds on my machine with SSMS v17.9: DECLARE @outer_loop INT = 0, @big_string_for_u VARCHAR(8000); SET NOCOUNT ON; WHILE @outer_loop < 50000000 BEGIN SET ...
0
votes
1answer
34 views

Incorrect GrantedQueryMemory(KB) Value in SSMS Dashboard report

Just checking by to see if someone else has witnessed the same and tried a fix or has been fixed: Issue: I ran below query on stackoverflow2013 database select ParentId as [Post Link], count(...
0
votes
1answer
30 views

Intellisense Not Working in SSMS 2016 [duplicate]

I am working with an Azure SQL Server database in SSMS 2016. I have Intellisense enabled in Tools -> Options -> Text Editor -> Transact-SQL -> Intellisense, however I have never had Intellisense ...
3
votes
0answers
38 views

Slow Connection to Azure SQL Database using SQL Server Authentication

In SSMS, when connecting to any of our Azure SQL Databases using service accounts and SQL server authentication, the connecting itself can take between 10 to 15 seconds to establish. Once connected, ...
0
votes
1answer
59 views

Unable to install SQL Server Management Studio (SSMS) on server

We are experiencing persistent errors when attempting to install SSMS on one of our development database servers. We have tried the installers for versions 17.4 and 17.9.1, but the error messages are ...
0
votes
1answer
13 views

Can't create any objects within OLAP database

Problem I can't create any objects under my databases in my Analysis Server. My context menus on all the folders under this test database just have Refresh as an option. Details My Analysis Server ...
0
votes
1answer
45 views

Do SET Statements happen in order?

Since I could not find it out here, do set statements happen in order scripted? Below is query I found. Would I get the same result every time it ran? DECLARE @Num VARCHAR(10) = '10'; DECLARE @...
0
votes
1answer
39 views

Not possible to install component to SQL Server Management studio 17.9.1

I am not able to install this component to SSMS version 17.9.1. There are two versions, one for the 64 bit & one for the 32 bit version of MS Office. I have a 64 bit OS installation. When I try ...
0
votes
1answer
113 views

Can I simply copy mdf and log files into the data folder to add a new database?

I have a copy of the mdf and log files of a database. The database is a MSSQL 2012 database. To use it, I did the following steps (a bit by chance actually, because I was trying to copy a mdf and log ...
1
vote
1answer
82 views

Bulk insert statement fails in SSMS with Operating system error code 5 (Access is denied.)

This issue was discussed in several places and it seems that general consensus is that if Windows Authentication is used then SSMS will access source file using Windows Domain user credentials. ...
0
votes
0answers
43 views

How to import a large .sql file to SQLServer via MSSQL?

I need to import a table from a .sql with size of 55GB. But i cant open it in Server Management Studio because of memory, there is a way to import this table query to my database of another way?
0
votes
1answer
50 views

“Active Directory - Password” login in SSMS for Azure AD - Password expired

I'm trying to connect to an Azure SQL DB through SSMS (v17.9.1), using an Azure AD user, that is an Active Directory Admin for my SQL Server that hosts my Azure SQL Database. I'm able to login with ...
0
votes
0answers
57 views

SSMS Error importing BACPAC

Im using Database > Import Data-tier Application to pull in my .BACPAC file and am getting this error: There is already an open DataReader associated with this Command which must be closed first. (...
0
votes
0answers
32 views

SSMS Results to Separate tab ignored on SELECT TOP 1000 Rows Right Click Menu

I have configured SSMS to display results to a separate pane which works fine when I create new queries using the "New Query" button. However, when I right click on a table and click SELECT TOP 1000 ...
0
votes
1answer
36 views

SQL Server Management Studio - Debugger buttons greyed

I have for mission to enable Transact SQL from a remote computer. My database is on a server and i'm trying to use the debug from a computer on the same network. My firewalls are all open on both side....
2
votes
2answers
84 views

SQL Server mistaken update rows without backup

I did a mistake UPDATE query yesterday. Database engine is MSSQL and the version is 2017. I have not any backups. All I have is the database itself. Do you know any ways to redo my modifications to ...
0
votes
0answers
82 views

Static Data Masking does not appear in SSMS 18 preview 6

I installed SSMS version 18 preview 6 and am using it with SQL Server 2017. I want to test the Static Data Masking feature, but the option does not appear.
0
votes
2answers
51 views

How to list permissions on a schema?

In SSMS, if you follow the path [Database] > Security > Schemas and view any schema properties, you have a tab "permissions" that list all the permissions that every user have on that specific schema. ...
1
vote
1answer
41 views

Oracle linked server shows all tables from all schemas in sql server management studio

I have created a linked server to an oracle database ( 12c ) in sql server management studio. I am mapping the local user to a special remote user in the oracle db. Connection is working fine. The ...
2
votes
1answer
57 views

SSMS - How to Enable Word Wrap for Messages Pane

Sometimes I need to take screen shots of error messages in SQL Server. How can I turn on word wrap in the messages pane so I can capture all the text in the screen shot?
2
votes
1answer
87 views

Is it possible to step through TSQL that uses variables, in SSMS?

If I enter TSQL into SSMS Query editor, I know I can "step through" the statements (ie. execute them one at a time) by highlighting a statement and hitting F5 on the keyboard. It seems by default ...
1
vote
1answer
46 views

Where to install or use SQL Server?

New to the database side of IT and I have a few questions... I'm trying to figure out what servers and databases I can access through SSMS. What is the best practice for installing/using SQL Server ...
1
vote
2answers
105 views

SSMS 2017: Open SQL Files in existing SSMS app with raised admin permissions?

I realise this is an old chestnut, but does anyone have a definitive solution? When SSMS (2017) is 'run as administrator', double clicking a SQL file in explorer will open another new instance of ...
0
votes
1answer
171 views

SQL Server Management Studio cannot connect because of common algorithm

I just installed SQL Server Management Studio, and I'm trying to connect to SQL Server 2014. It shows an error message "A connection was successfully established with the server, but then an error ...
1
vote
1answer
63 views

Connecting to SQL Express Server 2017 with SQL Server Authentication Remotely

I have two systems that are on the same network. I am able to ping back and forth between these systems with their IP address and with their system names. I have enabled the TCP port 1433 inbound and ...
0
votes
0answers
39 views

SSMS 17.9 instalation issue “DACFramework.msi”

I have issue to install Microsoft SQL Server Management Studio 17.9 on Windows Server 2016, I got following error and I have tried 32 and 64 bit version of DACFramework.msi and none of them worked.
0
votes
0answers
39 views

Is possible to select non consecutive lines of queries to execute in SSMS 2017

os: windows 10 ssms v17.9.1 Example If I want to run the first and the third query, the unique solution I find is select and comment(CTRL+K, CTRL+C) the second query and select the three query lines ...
0
votes
1answer
22 views

How present the result table below the last result query table, SSMS 2017

os: window 10 SSMS 2017, v17.9.1 I watched youtube videos of SSMS running two different queries and the last result was displayed below the last table. Example that I am referring in youtube. Now ...
6
votes
1answer
254 views

Execution plan doesn't show memory grant

I installed SQL Server 2019 on a VM on Azure (DS11). I am trying to illustrate adaptive query processing using this post here. The issue is that when I hit CTRL+L in SQL Server Management Studio to ...
3
votes
1answer
83 views

Reading 300% rows - Problematic execution plan

Whole queryplan and query: https://www.brentozar.com/pastetheplan/?id=BkgbANxN4 I am struggling with a query that uses a lot of time. The obvious reason for this is wrong estimates of amount of rows....
3
votes
2answers
185 views

SSMS - How to do case-insensitive searches in Object Explorer

Preface: I am not referring to queries. There are numerous places in SSMS that allow for filtering, such as the Object Explorer and Profiler, but these all treat filters as case-sensitive with no ...
3
votes
1answer
77 views

Availability Group Endpoints Windows Authentication Error

I have a two-node SQL Server 2016 Standard Always-On environment and when I create a new availability group, I receive the error message below: The Endpoints tab lists at least one endpoint that ...
6
votes
1answer
472 views

Exclamation point on plan guide

I created a plan guide using the following query: EXEC sp_create_plan_guide @name = N'Entity_Property fix', @stmt = N'SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value ...
0
votes
1answer
32 views

T-SQL - Script all tables creation, contraints, indexes, keys and triggers

I'm using SSMS and I was wondering if there is a script that can generate tables creation, constraints, indexes, keys and triggers for a given table names as a single result and another script that ...
0
votes
1answer
52 views

Cannot set up replication between two servers

I am trying to subscribe a 2016 (sp2, cu1) server to another 2017 server. I am getting the following error message: For merge publications, the version of the Subscriber must not exceed the version ...
0
votes
0answers
28 views

Can't connect to SSAS server — “Element 'return' was not found. Line 5, position 2.”

I'm trying to access an SSAS server from SSMS v17.4 (2017). I'm using Windows Authentication. I know the credentials are correct and can actually connect successfully from Visual Studio 2015. ...
11
votes
2answers
2k views

Where do you go to request new features in SSMS?

I'd like to ask Microsoft: To color code the pages in SSMS based on the server they are connected to Make it go ding when the query results are returned. Question: How do you ask for those features?
0
votes
0answers
24 views

SSMS Manage Help Content Error

I am not able to install Help Viewer 2.2 content in SSMS 17.9.1. I follow the steps in SQL Server offline help and Help Viewer, but after selecting content from the online source I get the error ...
0
votes
2answers
101 views

How to reduce the mdf file size in this database which I have 50 GB reserved space

I have a DB with 50 GB of size I need to reduce the size of it. How to reduce the file size of it? I already did this: shrink | files | selected 'Data' as filetype. but still it shows 50 GB Reserved ...