Super User Stack Exchange
Super User Stack Exchange

Questions tagged [ssms]

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

SQL Server Management Studio (SSMS) is a software application first launched with the that is used for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of SQL Server.

114 questions
45
votes
1 answer

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 icons disappear when I do a mouse over and then…
José Antonio Rodríguez Pascual
  • 453
  • 1
  • 4
  • 4
32
votes
2 answers

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 there are plenty of MySql admin tools, but it would be…
Alex KeySmith
  • 886
  • 3
  • 14
  • 31
24
votes
6 answers

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 Administrator. So I modified the properties of the…
AngryHacker
  • 18,217
  • 67
  • 156
  • 209
23
votes
4 answers

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 vertically attached to the query editor instead of…
Shevek
  • 16,502
  • 7
  • 46
  • 75
18
votes
8 answers

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 close it down, when I open it again, it opens on the…
user218317
13
votes
5 answers

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 Service Pack 1 for Visual Studio and some advanced…
Micro
  • 421
  • 1
  • 3
  • 15
8
votes
2 answers

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 'Invalid prefix or suffix characters. (MS Visual…
LondonPhantom
  • 959
  • 3
  • 10
  • 16
7
votes
6 answers

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 Server Management Studio, aka SSMS) don't appear…
Stephen
  • 775
  • 4
  • 11
  • 23
6
votes
3 answers

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. Thanks everyone! Original text: Each time I use…
DARKGuy
  • 258
  • 2
  • 6
  • 20
5
votes
2 answers

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 on VS2010 that we (finally) got color output for…
user978122
  • 439
  • 2
  • 7
  • 18
5
votes
1 answer

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 password?
Alex KeySmith
  • 886
  • 3
  • 14
  • 31
5
votes
1 answer

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 computer, but under search, there is only one SSMS…
KMC
  • 1,939
  • 9
  • 32
  • 43
5
votes
2 answers

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 reopening SSMS will solve the problem, but it is quite…
rcs
  • 881
  • 7
  • 13
  • 25
4
votes
1 answer

Avoid "The source conrol 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 you want to permanently remove the…
Nestor
  • 295
  • 1
  • 8
  • 17
4
votes
3 answers

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't use it (It fades). I am not sure because it is…
Richard Sayakanit
  • 333
  • 2
  • 3
  • 12
1
2 3 4 5 6 7 8