Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
45
votes
1
answer
14k
views
SQL Server Management Studio graphical glitches
I had installed SQL Server Management Studio 2014 and 2016 and the 2016 version had a strange behaviour. I uninstalled it and installed 2017, but it had the same behaviour. What happens is that some ...
34
votes
2
answers
109k
views
Anyway to use SSMS to connect to MySql?
I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection?
I realise ...
- 926
24
votes
6
answers
120k
views
How to Run an app as Administrator without the prompt?
When I start SQL Server Management Studio 2008, I get an error that's been around forever and is documented here. One of the suggestions to fix it that actually worked was to start SSMS with Run as ...
- 18.8k
23
votes
4
answers
16k
views
Floating or vertical results pane in SQL Server Management Studio
I have a multi monitor configuration and would like to be able to have my query editor on one monitor and the results pane on another.
Can this be achieved? Either by having the results pane ...
- 16.7k
18
votes
8
answers
33k
views
SQL management studio hangs when opening after being closed down on dual screen
I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014.
If I drag the management studio screen across to my 2nd display, and then ...
user218317
13
votes
5
answers
42k
views
Clean reinstall SQL Server Management Studio
I am on Windows 8.1, Professional edition. I installed SQL Server Management Studio 2012 x64 and everything worked well. I installed Visual Studio 2013 and everything worked well.
Then, I installed ...
- 421
8
votes
2
answers
15k
views
Sql Server Management Studio: Change Prefix or Suffix characters
I have an instance of SSMS 2008, for which the option to edit data in a table doesn't work. If I right-click on any table in the Object Explorer and select 'Edit top 200 rows' I get an error dialog '...
- 1,009
7
votes
6
answers
37k
views
what can I do if an application doesn't recognize horizontal scrolling?
I have a mouse with a horizontal scroll wheel (the MX Master by Logitech), but the horizontal scrolling is only recognized by some applications (e.g. Excel and Chrome).
Other applications (like SQL ...
- 804
6
votes
2
answers
11k
views
Avoid "The source control provider associated..... could not be found" message in SSMS
Every time I open my *.ssmssqlproj in SSMS i get the message:
The source control provider associated
with this solution could not be found.
The projects will be treated as not
under source control.Do ...
- 315
6
votes
2
answers
10k
views
SQL Server Management Studio CPU and RAM usage keeps increasing for no reason
I have a weird problem with SQL Server Management Studio, version 11.0.2100.60. When I was writing some query, sometimes the CPU gets hogged, and RAM usage keeps increasing.
Usually closing and ...
- 921
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. ...
- 258
6
votes
1
answer
6k
views
How are SQL server management studio passwords saved?
If, when connecting to a database with sql server management studio and you select "remember password"... where and how is it saved?
I presume it is somehow encrypted using your windows login ...
- 926
5
votes
1
answer
4k
views
SSMS version number
I had SSMS version 13 on my Win 8.1 64bits machine, and just downloaded the latest 16.5.3 SSMS. After installation, the SSMS I opened is still under version 13.0.16106. I tried restarting the ...
- 2,019
5
votes
2
answers
11k
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....
- 209
5
votes
3
answers
20k
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 ...
5
votes
2
answers
8k
views
SQL Server Management Studio print in color
I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas?
I know ...
- 439
4
votes
2
answers
12k
views
Unblocking Windows 10 Defender Firewall for MS SQL Server 2014
I have an instance of MS SQL Server 2014 (call it MSSQL) on a Windows 10 machine (call it WINTEN).
Running SSMS on WINTEN, I can connect to both the local SQL Server and also to SQL Server instances ...
- 1,715
4
votes
3
answers
2k
views
Is it possible to enable Intellisense for SQL Server Management Studio Express 2012 (SSMS)?
I have installed SSMS to connect with my Old SQL Server 2005. Just want to test new features for new version of SSMS Express 2012. I use Right click on the Text Editor to enable Intellisense but I can'...
3
votes
1
answer
3k
views
Installing SQL server express 2008 SP1 on Windows 7
I'm installing (well trying to) SQL server express 2008 SP1 on Windows 7
This is not working for me.
I started by installing VS2010 B2, it installed SQL 2008 Express.
I went into the 'SQL Server ...
- 6,359
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 ...
- 11.9k
3
votes
1
answer
2k
views
How do I change the default format for an date time value copied from SSMS to Excel
I often copy the results of a query from Sql Server Management Studio to Excel because I can fiddle with sorting and filtering of results faster using Excel's built in tools than by changing the query ...
3
votes
1
answer
125
views
SSMS 2008 indent on line break
I'm tired of using Tab key when I pressed Enter and Tab Key in SSMS editor because when I have something like this:
CREATE PROCEDURE SP_Example
BEGIN
SET NOCOUNT ON
SET DATEFORMAT ...
- 205
3
votes
0
answers
4k
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
- 143
2
votes
1
answer
4k
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 ....
2
votes
1
answer
3k
views
Always encrypt connection from SQL Server Management Tool
I've noticed that the "Encrypt connection" checkbox seems to default to unchecked.
Is there a way to default this to being checked?
- 133
2
votes
1
answer
287
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 ...
- 138
2
votes
2
answers
2k
views
Configuring VM with SQL Express to be accessed using SSMS from host
I'm trying to configure my VM with SQL Server 2008 R2 Express so that I will only be able to remotely access SQL using SQL Server Management Studio from host machine.
VM configuration
running ...
- 2,046
2
votes
0
answers
30
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 (...
- 218
2
votes
0
answers
239
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 ...
- 21
2
votes
0
answers
543
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 ...
- 21
2
votes
1
answer
2k
views
How can I connect to sql server from a different domain/network
I installed SQL Server 2008 R2 on 6 machines. They are to be placed in 2 offices, 3 in each.
I created a database instance and I used VB6 and was able to link both perfectly.
I was also able to ...
- 21
2
votes
1
answer
2k
views
Loading Files from My User Directory in SQL Server Management Studio 2012 Under Windows 8
I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible ...
- 450
1
vote
2
answers
5k
views
How do I get a standalone SQL Server Management Studio (SSMS)?
I don't want to install the entire SQL Server (2005 or 2008) on my Virtual PC (saving space), yet I need the SSMS to connect to external databases.
What are my options?
- 1,079
1
vote
2
answers
4k
views
SQL Server Management Studio: Database Attachment Failed
I have publish my website in IIS7. It is running in DefaultAppPool. The Identity of this app-pool is set to LocalSystem. The IIS is running and I can run the application from IIS without any problem.
...
- 145
1
vote
1
answer
383
views
SSMS view designer - how do I give a table an alias?
I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible.
Case in ...
- 930
1
vote
1
answer
471
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 ...
- 21
1
vote
1
answer
439
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 ...
- 6,525
1
vote
1
answer
742
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 ...
- 11
1
vote
1
answer
166
views
SSMS 2008 is stuck because Connect to Server window is hiding
Launching SQL Server Management Studio 2008 after rdp or similar display config funny business, the Connect to Server window is sometimes hiding in the corner of a monitor. The program seems stuck, ...
- 125
1
vote
2
answers
6k
views
Errors during installation SQL Server Management Studio (ssms) on 64-bit Windows7
I have been trying to install SQL Server Management Studio (ssms) on a 64-bit Windows7 for two days now and it just doesn't work.
On a otherwise completely clean 64-bit Windows7 system I get the ...
- 1,377
1
vote
0
answers
233
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.
...
- 11
1
vote
0
answers
204
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 ...
- 86
1
vote
1
answer
3k
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 ...
- 11
1
vote
1
answer
708
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?
- 11
1
vote
0
answers
499
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
...
- 11
1
vote
0
answers
356
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 ...
- 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 "...
- 11
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 – ...
1
vote
0
answers
47
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? ...
- 11
1
vote
0
answers
810
views
Can't connect to database in SSMS 2017
I used to be able to connect, and now I can't. I have tried uninstalling and reinstalling SSMS. I have not changed my antivirus/firewall settings at all.
OS: Windows 10 Home
TITLE: Connect to Server
...
- 1,182