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
119k
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 ...
- 794
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 ...
