Questions tagged [ssms]

SQL Server Management Studio is an IDE for administering Microsoft SQL Server.

Filter by
Sorted by
Tagged with
0 votes
2 answers
452 views

after upgrade to win11 runas.exe no longer passes windows credentials to SSMS

On Friday I had to change my domain password and my employer upgraded my machine to Win11 over the weekend. There also seems to have been an upgrade to our security software. Not sure which parts of ...
volfied's user avatar
  • 11
-1 votes
1 answer
256 views

How to uninstall SSMS 19.1 completely with absolutely all settings?

SSMS 19.1.56.0 English-US Windows 10.0.19044 I want to remove it absolutely completely with all settings. After a re-install, it should behave like installing on a fresh computer. Currently, when I ...
askolotl's user avatar
  • 132
0 votes
1 answer
163 views

Occasional empty folders in Object Explorer tree in Microsoft SQL Server Management Studio

I'm using Microsoft SQL Server 2022 Express and Microsoft SQL Server Management Studio 19.1 on a fresh Windows 11 Pro installation. From time to time, after connecting to my localhost\SQLEXPRESS ...
Miłosz's user avatar
0 votes
0 answers
44 views

SSMS keyboard shortcut for save only the focused Query

I am running SQL Server Management Studio 19.1.56.0 with a project solution that has about 10 Queries. When I save, either with Ctrl+S or Ctrl+Shift+S and default keyboard shortcuts, SSMS will ...
Eric's user avatar
  • 13
0 votes
0 answers
142 views

Microsoft SQL Server Management Studio starts to consume 100% of CPU after a while when the VPN connection to the SQL Server is disconnected

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. This question does not appear to be about programming within the scope defined in the help center. ...
maresplace's user avatar
0 votes
0 answers
190 views

Multiple values using the N prefix

I need to put multiple values in the @RefValue parameter to speed up the result: I tried : @RefValue = N'204' --205 ' however, it only returned the value of the register 204. Command: DECLARE @...
Clamarc's user avatar
  • 623
3 votes
0 answers
2k views

Can't install ODBC Driver 17 for SQL server On Windows 11

i want install SSMS 19.1 this is stuck like picture the problem for "microsoft ODBC Driver 17 for SQL Server" cant install i download it manually and try install it but this error appear
abbas-h's user avatar
  • 143
0 votes
0 answers
354 views

SQL Server database upgrade - 2016 to 2019

We upgraded our SQL server from 2016 to 2019. Now we need to upgrade/convert our custom 2016 database to make it 2019 compatible. What's the process? We are running SQL Server management studio 2019 ...
yonikawa's user avatar
  • 129
1 vote
0 answers
167 views

copy ssms query result and paste as table in ms teams

is it possible to copy results from ssms results and copy that results into ms teams chat as table? What I do now is that I copy data from ssms into excel and from excel I copy into MS Teams. But I ...
vondravl's user avatar
0 votes
1 answer
2k views

How to open SSMS as a different user using username and NOT using email address?

I am trying to run SSMS as a different user and it is not letting me run as a different user. It is asking for email address instead. How to get around this issue? Thanks in advance. I have tried ...
Puneeth C's user avatar
1 vote
1 answer
581 views

Why are my Database Diagrams now blank after upgrading to SSMS 18.12.1

I upgraded SSMS this morning to 18.12.1, but when I open my database diagrams all of them are displayed as blank pages. How do I fix this?
Kevin's user avatar
  • 11
-1 votes
1 answer
853 views

Installing SSMS in Windows Core

I'm trying to: start "" /w ".\smss-setup-enu19.exe" /passive ssmsinstallroot="c:\program files\ssms" but encountering this error:↓ (syntaxes using " around path and ...
mgae2m's user avatar
  • 35
0 votes
0 answers
20 views

Save SQL Server 'Server Name' values when running SQL Server as user with different domain

So I need to periodically run SSMS as a user other than the windows user I am logged into my machine as. This user has a different domain than the user I am logged into my computer as, therefore what ...
Siah's user avatar
  • 1
0 votes
0 answers
1k views

ODBC with active directory password authentication using a login ID and password not configurable

The server MYSERVER holds the SQL database MyDatabase. The account MYCOMPANY\myaccount is registered for MyDatabase with server roles public and sysadmin and with permission Connect SQL granted by sa. ...
stonebe's user avatar
  • 207
0 votes
0 answers
240 views

copy-paste issue when using SSMS over GoToMyPC

I'm hoping someone here has run into this issue and knows if there's a fix for it. When using GoToMyPC, I'm unable to copy text from the editor in SSMS (v14) on my remote desktop and paste it into the ...
Tim's user avatar
  • 817
1 vote
0 answers
432 views

SSMS 18.9.2 Crashing shortly after loading

I'm running SSMS 18.9.2 on a Windows 10 computer. SSMS crashes as soon as I start typing in an SQL template, as soon as an auto-complete list pops up. I get the following from Windows Event Viewer ...
Clemens's user avatar
  • 11
0 votes
0 answers
2k views

Unable to install MS SQL Server or SSMS due to missing DLL, how do I find and install this DLL?

I have the exact issue as the OP of this question but their fix did not work for me: Related Stack Overflow Question I need to install MS SQL Server and SQL Server Management Studio on my computer. No ...
user2731076's user avatar
2 votes
0 answers
25 views

Preserve shortcuts in SSMS after restart

I use SQL Server Management Studio in this version: Microsoft SQL Server Management Studio 14.0.17289.0 Microsoft Analysis Services Client Tools 14.0.1016.283 Microsoft Data Access Components (...
pavelsaman's user avatar
0 votes
1 answer
31 views

Hello is there are keyboard shortcut for switching to the messages tab?

I have looking around by a lot but I did not find anythink. Any ideas?
user avatar
0 votes
1 answer
412 views

From Powershell, Open Multiple SQL files in a single SSMS Instance

I have an automated Powershell process that ends with an Invoke-Item command to open multiple SQL files (currently 4 SQL files) for the testers, so they can run their scripts. Keep in mind, I am not ...
DBADon's user avatar
  • 483
0 votes
1 answer
205 views

SSMS - executing two ALTER table statements concurrently for same table

Are there known issues with executing two ALTER table scripts for the same table? Both scripts alter the datatype for one (but different) column in a table? I'm wondering if one script finishing and ...
Curious's user avatar
6 votes
3 answers
3k views

How to mute windows beep sound in SSMS 18.5 everytime you tab in the table designer?

FOUND THE ISSUE: Seems it's not a known bug and I've reported it on their Uservoice. This seems to happen only on SSMS 18.3.1 onwards up to SSMS 18.5. On SSMS 18.2 and lower the issue does not happen. ...
DARKGuy's user avatar
  • 258
2 votes
0 answers
229 views

SSMS 18.5 installation

I'm a bit of a novice and struggling to install SSMS on my PC. I have recently had to reinstall Windows 10 and now cannot get SSMS to install. I have downloaded the latest version of SSMS from ...
bertygerty99's user avatar
0 votes
1 answer
901 views

Is it possible to change the font size in SSMS log file viewer?

I'm using SSMS 18.2 and find that the font size inside the log file viewer window (reachable via "Object Explorer" -> "Management" -> "SQL Server Logs" -> Current") is very small, probably below 8 ...
Marc C's user avatar
  • 3
2 votes
1 answer
274 views

Apex SQL complete freezes SQL management studio

I am using SSMS 18.4 I installed APEX sql complete, and every 30 minutes it freezes my management studio. So I'd have to go to Task Manager and end it from there. Did anybody have issues like ...
Serdia's user avatar
  • 138
3 votes
1 answer
1k views

Is there a way to make the I-beam cursor bigger or thicker in Windows?

Is there a way to make the I beam cursor bigger or thicker in Windows? I can make the regular cursor (arrow) larger by using a different .cur file. In some windows like the query window in SQL Server ...
Tony_Henrich's user avatar
  • 11.7k
5 votes
2 answers
9k views

Where is the SQL Configuration Manager in SQL Server Management Studio 18?

I am setting up a new computer, a Surface Laptop 3. I have installed SQL Server Management Studio 18.4, downloading it from here. I am just trying to install client tools and not the server software....
Reboog711's user avatar
  • 209
0 votes
1 answer
2k views

Cannot connect to reporting services from SSMS MSSQL 2017?

I have installed MSSQL Server on localhost although when I try to open reporting services from ssms v18.3.1 I get the following error message: Unable to connect to the server at DOMAIN\SSRS. The ...
Johnny Adams's user avatar
0 votes
1 answer
305 views

sql server management studio 2017 (v.17.8.1) - how to open multiple .sql files at once in same instance

I would like to be able to multi-select stored procedures in SSMS then right click > open and have all the selected files open in different tabs of the same SSMS window. Looking online I can find ...
user avatar
0 votes
1 answer
36 views

Is SQL Server 2000 Keyboard Scheme available in SSMS 18?

In Sql Server Management Studio (SSMS), at least up through version 2008 R2, we've had the ability to set the keyboard scheme to "SQL Server 2000" (Tools > Options > Environment > Keyboard) ...
katzbatz's user avatar
  • 101
0 votes
1 answer
187 views

AutoComplete menu Manipulation in Microsoft SQL Server Management Studio 18.2(2019)

when writing a query And Autocomplete menu Appears, is it possible to go up or down on the list without using the arrow keys? they are so far away from where my hands are. maybe by a key near the ...
Liron Hazan's user avatar
-2 votes
1 answer
87 views

SSMS 18.2 gives error when performing DDL

We upgraded to SQL Server 2016 SP1 and SSMS 18.2 last week. Today I've been trying to execute DML in the database and am getting this error message: Msg 208, Level 16, State 1, Procedure ...
J Szoke's user avatar
1 vote
0 answers
250 views

How to set up SQL User that can only do one thing (run stored procedure) and nothing else?

I would like to allow any user within a certain group of our domain access to login to one of our databases and run a specific Stored Procedure. This is the only action these users should be able to ...
Tyler N's user avatar
  • 983
1 vote
0 answers
24 views

Re-use An Import-Mapping of a CSV into SQL Azure DB using SSMS

In https://stackoverflow.com/questions/12503430/import-csv-into-sql-azure-database-using-ssms/35876305#35876305 one solution was to save the import dtsx so as to reuse. However, I cannot find how to "...
Eric Hofer's user avatar
0 votes
1 answer
73 views

My new installation of SQL Server Management Studio 18.2 have a trouble with its UI

Every time I start the applications it's UI is disappearing. Like this Disappearing UI, or like this Disappearing UI Please help me to solve that problem. Thanks for your attention.
Strefforts's user avatar
0 votes
1 answer
707 views

SSMS Import and Export Wizard - Error importing excel data

My dev machine setup: Windows 10 64bit Office 2016 64bit SSMS 17.6 I connect to a machine running SQL Server 2016 64bit. I am trying to import data into my database using an excel file. When i try,...
dk96m's user avatar
  • 101
1 vote
1 answer
426 views

Outlining while modifying a multistatement function in SQL Server Management Studio

When coding in an empty query window, IntelliSense gives me useful collapse/expand buttons on each BEGIN-END statement to hide underlying code, apparently called "outlining". However, when I ...
jeroenymo's user avatar
0 votes
1 answer
561 views

SSMS throws System.OutOfMemoryException on every query

I've been running into some performance issues in SSMS recently, hanging and slow downs but now I'm starting to see any query I run throw an out of memory exception. Even something as simple as "...
user1061361's user avatar
0 votes
1 answer
300 views

For Sql Server Management Studio, in the year 2019, how to report a bug to Microsoft?

I ran into a fatal bug in the latest (18.1) release of Sql Server Management Studio, or SSMS. I went to report the bug to Microsoft, but various means to do so in the past have been shut down. There ...
Larry Smith's user avatar
2 votes
0 answers
522 views

Sql Server Management Studio 18.1

I recently installed SSMS 18.1 and I am having an issue when trying to drag and drop table names from the object explorer to the query window. For example, I am writing a query and dont want type out ...
VVander's user avatar
  • 21
1 vote
0 answers
31 views

SSMS 2014 reporting service configuration ,Reporting Services – SharePoint integrated mode option is not working

I uninstalled SSMS 2014 due to some reason and when i went reinstalling it i am facing an issue that Reporting Services – SharePoint is not highlighted in feature selection and Reporting Services – ...
Jaspreet Singh's user avatar
0 votes
2 answers
2k views

Microsoft SQL Server Management Studio 18 fails to start after installing XAMPP/MAMP on Windows 10

When I try to launch SQL Server Management Studio 18, I get a Windows chime and no other response or error messages. Initially, after installing SSMS 18 and SQL Server 17, both worked fine for a day ...
Gerry's user avatar
  • 1
0 votes
1 answer
312 views

Keyboard Shortcut for Filling in Parameters in SSMS Stored Procedure

Does anyone know the keyboard shortcut that calls the SSMS tool window for filling in the parameters of a stored procedure template?
Jake Geers's user avatar
5 votes
3 answers
19k views

Cannot uninstall SQL Server Management Studio 18 after forcefully stopping setup midway

I installed SQL Server 2017. It installed fine. I connected and turned it on (the server). Worked fine. Then I downloaded the SSMS 18 setup. When I started the SSMS setup exe, it progressed to half ...
Raphael Nazirullah's user avatar
1 vote
1 answer
411 views

Live Filtering Object Explorer in SSMS

Are there any tools or extensions that all you to live filter database objects inside SQL Server Management Studio's Object Explorer? Here's what Currently Exists The Out-of-the-box functionality ...
KyleMit's user avatar
  • 6,315
0 votes
1 answer
244 views

After installing SQL Server Studio 2017 with Integration and Reporting services, in the Integration Services Catalogs- Create New Catalog shows error

SQL SERVER Management Studio 2017 - The error says "The catalog backup file 'C:\SQL\SHARED\X64\140\DTS\Binn\SSISDBBackup.bak" could not be accessed. Is this error fixing requires "Integration ...
sql_nc2019's user avatar
0 votes
1 answer
2k views

SQL Studio Management Studio Import/Export wizard crashes when attempting to import a flat file

I'm having a strange issue with users who try to import a flat file into an SQL database. It happens immediately when they click Import Flat File, they never actually get into the Wizard. (right-click ...
Jeff Lohr's user avatar
0 votes
0 answers
12 views

SSMS runs very slowly if even a medium number of rows are returned in Results Pane

I'm using SSMS 2017 and have an issue that means as soon as I have even a small number of rows (10,000)the user experience lows down. I do have Redgate SQL tools installed, but colleagues have the ...
Anthony Blyth-Work's user avatar
0 votes
1 answer
26 views

How to configure Microsoft SQL server management visual studio

TITLE: Connect to Server Cannot connect to desktop-57. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was ...
Faraz's user avatar
  • 1
1 vote
1 answer
618 views

Check Status of All SQL Services

I wanted to List all the SQL Services including Reporting Services. Wmic service where (PathName like '%Binn\%sql%') get caption, name, startmode, state, PathName, ProcessId This one will give all ...
Sandesh's user avatar
  • 11