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.

1
vote
0answers
20 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?
-1
votes
0answers
33 views

Adding Substring in a join query in MSSQL

I have a query and i want to parse a column data and add the result into the query below. Is there a way to do this. I get an error when i get more than one result. Thank you. select b.JOBNAME as Km,...
3
votes
0answers
76 views

SQL Server job will not run

I am trying to get a job to auto run that syncs a csv file into a datatable. I have tried everything I have found online. Here is my set up. I have a a login credential with myself as the identity, ...
15
votes
1answer
952 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
22 views

Intellisense Not Working in SSMS 2016

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
26 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
31 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
42 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
32 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
60 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
63 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
40 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
25 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
34 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
30 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
32 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
36 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
38 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
32 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
42 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
45 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
57 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
97 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
56 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
32 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
19 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
244 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
79 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
162 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
71 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
468 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
31 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
24 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
21 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
76 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 ...
1
vote
2answers
98 views

SSMS does not open popup wizard to create a new schema

When I right click on 'schemas' and then on 'create new schema' my SSMS only opens the query editor but on every tutorial I saw a pop up wizard opens instead. How can I access this popup wizard? I can'...
0
votes
4answers
57 views

Creating a database from a backup file

I have a peculiar issue on my hands. I have a few databases in my SSMS already (2014), and when creating a new database and performing a restore from a file that has never been used, it sets my main ...
0
votes
2answers
57 views

How to view xEvent event_file data

I have a small xEvent that is sending the results as .xel to an event_file in G:\XEvents and I want to explore the data with SSMS. I have been looking for a solution and found several posts about ...
0
votes
1answer
39 views

Server version error where restoring backup with SQL Server Management Studio

I have SSMS v17.9.1 freshly installed. I believe the only later versions as of this post's date and time are only preview versions. I am attempting to restore a .bak file. I get the error that: The ...
0
votes
0answers
24 views

Maintenance plan changing from ALL USER DBs to SELECT DBs automatically

We came across an odd bug in Maintenance Plans on SSMS 2016 and 2017 for SQL Server versions 2012 and 2016 (at least). The setup is unusual, but I couldn't find anything about this or any similar ...
1
vote
2answers
47 views

Restore a single database backup (.bak) file into multiple filegroups

I have a SQL Server 2014 database DB01 (single filegroup - PRIMARY) and I took a backup of it into a DB01.bak file in SSMS. I have another database DB02 with 1 primary filegroup (1 file) and one ...
0
votes
1answer
18 views

Can I ignore queries about extendedproperty?

I want to reuse the structure of a database in a new project. So using SSMS I use Generate Script and in settings I set to generate schema only. In the result there are too many queries about ...
0
votes
4answers
94 views

SQL SSMS want to shortcut “Edit View”

I usually right click on a view or a stored procedure and then choose Script View -> Alter -> In New Editor Window. Is there a way to shortcut this - either on Keyboard or on direct menu entry?