Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
108
questions
0
votes
0answers
7 views
Have SSMS not retrieve VARBINARY(MAX) blob data for “Select Top 1000 Rows”
I'm using SQL Server 2017 and SQL Server Management Studio ("SSMS") v18.5.
In my database, I have a couple tables that have blobs stored in VARBINARY(MAX) columns in tables that look like this:
...
3
votes
2answers
177 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. ...
2
votes
0answers
80 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 ...
0
votes
1answer
69 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 ...
1
vote
0answers
48 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 ...
3
votes
1answer
78 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 ...
1
vote
1answer
1k 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....
0
votes
1answer
181 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 ...
0
votes
1answer
30 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 ...
0
votes
0answers
10 views
Microsoft SQL Server Management Studio 2016 Save Changes popup
Any word if Microsoft will ever update the Save Changes popup to not appear in SQL Management Studio?
It is spectacularly annoying. I have heard someone argue this is similar to all other Office ...
0
votes
1answer
9 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)
...
0
votes
1answer
48 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 ...
1
vote
0answers
10 views
Missing options in “Script table as” in SSMS
I have tried the great and mighty google but it has failed me. I am missing some menu options in my SSMS under "Script Table as". I've checked my access to the database, looked through the toolbars ...
0
votes
0answers
38 views
Exporting xel file to Azure SQL DB using SSMS extended events wizard
I have an extended events .xel file on my local machine that I'm trying to export as a table to an Azure SQL DB, using the extended events export wizard in SSMS v18.2.
I can connect to the database ...
-2
votes
1answer
19 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 ...
0
votes
0answers
36 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 ...
0
votes
0answers
16 views
Using SSMS, can I create linked server without having SQL Server installed?
I am trying to use SQL Management Studio to connect to a PostGreSQL database. I do not have a license for SQL server, but is the environment I am comfortable in. I was hoping to just create a linked ...
0
votes
0answers
37 views
Microsoft SQL Server Management Studio - Purple Highlight on text and purple square appearing
Program - Microsoft SQL Server Management Studio
Version - 18.2
Issue - Everything I type in a query is highlighted purple, there is also a purple square appearing on the right side that doesn't seem ...
1
vote
0answers
16 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 "...
0
votes
1answer
62 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.
0
votes
1answer
236 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,...
0
votes
1answer
75 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 ...
0
votes
0answers
28 views
Getting Error while installing SSMS 18.1
I have installed SQLSERVER 2017 in my machine, In addition to that trying to install SSMS 18.1 release. While installing getting the attached error message. How can I unblock the setup?
0
votes
1answer
108 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 "...
0
votes
0answers
56 views
Not able to access SQLServer Database From Data Link Properties Tool
I am facing a strange issue with SQL Server database connection, I can able to connect Db Server from SSMS but when I connect through Data Link Properties Tool it gets failed.
I have tried to connect ...
0
votes
0answers
19 views
Client side connection issues. Connecting to SQL server 2017 from 64 bit brand new Surface tablet
I have been trying for 2 days to connect a new tablet to our SQL server. We usually have no issues and I have at least 10 other devices set up exactly the same way on the same network with the same ...
0
votes
0answers
12 views
SQL Server Management Studio (Modifying Stored Procedures)
hoping you can help.
I've used SSMS for a long time and all of a sudden when I modify a stored procedure it now wants me to edit a string instead of using Alter directly. Here's an example
IF ...
-1
votes
1answer
123 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 ...
0
votes
0answers
241 views
SQL Server symbol meanings
Is there a glossary available that lists the meaning of all the different symbols in the object explorer in ssms(see below for example). I have come across this question that explains some of the ...
0
votes
0answers
16 views
Importing Flat File Into SSMS Results In Incorrect Dates In Database
I am an SQL student who has been tasked with loading data into SQL for a company that I intern with. I have tried loading multiple flat files with dates formatted as 1/23/2004 into SSMS and when going ...
2
votes
0answers
410 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 ...
1
vote
0answers
27 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 – ...
0
votes
2answers
772 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 ...
0
votes
1answer
69 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?
2
votes
2answers
5k 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 ...
1
vote
1answer
122 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 ...
0
votes
1answer
158 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 ...
0
votes
1answer
339 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 ...
0
votes
0answers
9 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 ...
0
votes
1answer
19 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 ...
1
vote
1answer
73 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 ...
0
votes
0answers
30 views
Allow access to SQL Server Management Studio only to admin account
I would like to allow only administrators to access to SQL Server Management Studio using "Windows autentication". How can I avoid simple users to access with Windows autentication? Or in alternative ...
0
votes
1answer
60 views
failed to connect to server when using default instance
When trying to connect to a database using the default instance name [server]\[instance] I get:
Cannot connect to RT-WEB\SQLEXPRESS
--> A network-related or instance-specific error occurred ...
0
votes
1answer
130 views
SQL Import/Export Provider not Registered
I am using SSMS "008 R2 on my Windows 10 64 Bit PC and when I try to use the import wizard to import from a spreadsheet (Office 365 ProPlus 64 Bit) I get an error message which says The 'Microsoft.ACE....
0
votes
1answer
84 views
SSMS increase size of box Avaiable Databases
In SSMS (SQL Server Management Studio) there is a meny item Available Databases. I would like to increase the size of that box since there is some databases with long name that I would like to see the ...
0
votes
1answer
16 views
using Sql Management Studio 2008 list past connections
when you open up sql management studio you can select server, and get a list of remembered connections. I don't care about getting pw and but I would like a list of remembered or past connections. ...
1
vote
0answers
16 views
open SQL Server Management Studio from another machine
I have SQL Management studio installed on my VM and I use VDI to access VM. the only reason i login into VM to access the SSMS. Is there is any way i can open the SSMS from VDI without login in to VM? ...
2
votes
1answer
2k views
SSMS wont give up file associations
Apparently this is a known Win10 bug and should hopefully be fixed in an upcoming update.
I have installed SQL Server Management Studio v17.9 on a clean Windows 10 installation. This associated all ....
0
votes
0answers
1k views
I get “rsProcessingAborted” and “rsErrorExecutingCommand” randomly in my SQL Server Report builder report
I have a report in which I get randomly the following error after pressing the "View Report" button (because in this report I need to select a parameter value from the dropdown field first):
An error ...
0
votes
1answer
61 views
How to get rid of mixed language in Microsoft SQL Management Studio 2017
A German version of SSMS 2017 is already preinstalled on my machine. I want to get the English version.
After re-installing the English version, my UI is mixed up with half English, half German.
How ...
