SQL Server
Microsoft SQL Server powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and a leader in TPC-E. It scales to petabytes of data and allows customers to process big data through PolyBase using T-SQL over any data. SQL Server has also been the least vulnerable database during the last seven years. SQL Server brings data insights with business intelligence capabilities that provide analytics at a fraction of the cost on any device along with advanced analytics with support for R and Python.
-
SSMS 18.0 redraw issues when switching between multiple query windows
SSMS 18.0 redraw issues when switching between multiple query windows
Repro:
1. Open SSMS
2. Open a new query window and enter and execute a command, such as:SELECT @@SPID;- Open a second query window
- Using your mouse, switch back and forth between the two open query windows by clicking on their tabs.
- After several clicks (five to ten?), the content of the first window (query and result pane) may appear to be displayed in the second window, but you can't interact with any of the text.
- Switching back and forth a few more times may clear up the issue…
347 votesThis issue was fixed (or better, mitigated) in SSMS 18.5
As you can see, SSMS will automatically prevent the Visual Studio Shell from using the h/w acceleration.
While I hear that for some of you this workaround did not help, it seems that for the vast majority of the people here it was beneficial, so the workaround has been baked into SSMS 18.5.
Thanks,
-Matteo -
SSMS Crash when dragging table from Object explorer into new query window
Have just installed this version v18.1 and everytime I drag a table from Object explorer into new query window SSMS crashes, I have to kill it.
I have no add-ins installed, have rebooted since installing.O/s Win 10 15063.1387
129 votesThis has been fixes. Please try the latest version of SSMS – 18.5 and let us know if you are still seeing this issue.
thanks
Dinakar -
Visual Studio 2017 SSDT adds hardcoded master.dacpac include
Visual Studio 2017 seems to add a hardcoded path to the master.dacpac if I include it in a project of mine. Older versions of the SSDT used the $(DacPacRootPath) variable to get the master.dacpac.
This is really annoying as it breaks the builds on our build server where the master.dacpac is installed in a different folder than on my development machine.
96 votesThis was fixed in VS 2017 15.9.13:
https://docs.microsoft.com/en-gb/visualstudio/releasenotes/vs2017-relnotes#-visual-studio-2017-version-15913thank you,
Drew
-
SSMS 18.0 GA can't be installed
When I'm trying to install SSMS 18.0 GA, I get error: "SSMS can only be upgraded by installing the package of the matching language. Please, use the matching version of the installer, or uninstall the current version of SSMS and run SSMS setup again." And I'm not alone: https://social.technet.microsoft.com/Forums/en-US/16d0e279-6ff4-4d5f-ad0a-5039235f03b9/ssms-2018-setup-blocked?forum=sqltools
45 votes -
SSMS 18.2 default language display bug
Hi, SSMS 18.2 displays the default language for all logins as Arabic, and my default language is us_english.
I'm using language 1033 so this shouldn't display as Arabic. I tried with a few servers - all the same. This is across all versions of the database engine from 2008, 2012, 2014, 2017 etc.
querying sys.server_principals shows this isn't actually the case so this seems to be display bug in SSMS 18.2
39 votesThis issue was fixed in SSMS 18.3.1
Thanks,
-Matteo -
SSMS 2016 does not remember added SQL Snippets folder
You can add your own snippets in SSMS bij using the Code Snippet Manager.
In the Code Snippet Manager window you have the possibility to add a folder containing customer snippets by using the "Add..." button.
This works fine as long as you're not closing SSMS. After restarting SSMS you have to add the folder again because it is no longer available in the snippets.32 votesFixed in SSMS 18
-
Remove the word "Initial" in SSMS, Object Explorer, Database Properties, Files.
Right-click a database, Properties, Files. There's a column named "Initial Size (MB". The word "Initial" should be removed. It is incorrect to have that word there. What we see here is the current size. This is particularly confusing for tempdb since people tend to think that what you see here is indeed the initial size (size at startup, from sys.master_files), which is not correct. Again, you see the current size!
32 votes -
SSMS 18.2 Edit Job Step hangs
In SSMS 18.2 when we edit a job step under Job properties it takes minutes to open the edit box
29 votesThis has been fixed in 18.5.
thanks,
Dinakar -
SSMS bug: missing ellipsis for truncated field values (Results to Grid)
This bug led me to think the values were different than actual ones: sometimes, when truncating values due to column width, SSMS 2017 (17.7) doesn't put ellipsis (…) in the end of the truncated value, and users are misled to think the value is not truncated.
29 votesPeter is correct. This appears to have been introduced with the Creators Update of Window 10. We reported this to them and in our testing this issue seems to be fixed with the October Update of Windows 10.
-
SSMS: Setting for declining Intellisense not respected in SSMS 18.
The first thing I do when I get a new install is to go do settings and change a few things to my liking. On of these things is to turn off Intellisense.
However, this is not respected in SSMS 18, but when I open a new query window, Intellisense is still enabled. Sometimes the icon is lit in the toolbar, but it does not really seem to be active. But far too often this is. This is extremely irritating.
24 votes -
SSMS2018 - Installed, but will not run
Original post is here, with additional customer failure report: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/76236e43-dc82-4586-bf7f-b01ff6374462/ssms2018-installed-but-will-not-run?forum=sqltools
Windows 2016 Standard Edition. Brand new Hyper-V image. No prior SSMS on the server. Freshly installed SQL 2014, 16, and 17, Standard and Enterprise as 6 named instances. Restarted multiple times. Repaired the SSMS install. Restarted. I chose to install in a named folder: C:\Program Files (x86)\SSMS18 ..\Common7\ Size on disk: (1,090,367,488 bytes)
All that shows is the splash screen, then nothing. Run as administrator - I am a Local Admin - nothing.
Event Viewer - Nothing.
Uninstalled. Reboot. Reinstalled to default location.
WORKS FOR ME, but NOBODY ELSE on…
22 votesThe fix for this issue was included in SSMS 18.1.
Thanks,
-Matteo -
SQL Server Management Studio: Restore Database from Device HANGS on clicking "..."
When I wish to restore a database from a .back file, I go into SSMS, select Tasks->Restore Database, and on the dialog, I click the "From Device" radio button, and then click the "..." button to browse to the .bak file I wish to restore. This then HANGS for MINUTES before the "select a backup device" dialog appears and allows me to drill down and select the backup file.
I have literally HUNDREDS and HUNDREDS (maybe THOUSANDS) of *.bak files on a big data drive with lots of folders. It seems like it might be trying to iterate over all…
20 votesPlease, try SSMS 18.3.1+
This should be fixed.
Thanks,
-Matteo -
SSMS 17 Tools > Options > Environment > Fonts and Colors missing Display items
In a generic SSMS 17.2 install on a Windows 7 64-bit workstation, if I open Tools > Options > Environment > Fonts and Colors, I only get 3 items in the 'Display items:' list: Plain Text, Selected Text, and Inactive Selected Text. I have no options to change anything else. In my SSMS 2016 install, I have over 200 items in the 'Display items:' pick list. Comparison screenshot here: https://imgur.com/a/XiGMm
I have tried resetting all settings to default in the Import and Export Settings Wizard. No change.
19 votesThis issue has been fixed in SSMS 18.x
Thanks,
-Matteo -
The DELETE key does not work as expected when trying to rename a database object in Object Explorer.
The DELETE key does not work as expected when trying to rename a database object in Object Explorer. The BACKSPACE key works correctly.
16 votesPlease, give SSMS 18.0 a try. The issue should be fixed now.
Thanks,
-Matteo -
SSMS 17.5 Intellisense not working for Azure Server
I am running SSMS 17.5 and attaching to an Azure server with 35 Databases and over 50 users.
If I connect to a local DB intellisense works fine. On the Azure server there is nothing. No Intellisense at all. It is turned on (TextEditor -> IntelliSense -> Enable Intellisense) and working against other servers.
My questions are:
Could this be a bug in SSMS 17.5?
Is there a setting in SQL server to disable Intellisense queries?13 votesThis has been addressed.
Please, give it a try on the latest version of SSMS (17.9 currently).
-
SSMS 17.6 crashes when clicking on a schedule in a maintenance plan
SQL Server Management Studio 17.6 (version 14.0.17230.0) crashes when I click on the schedule icon for a subplan (from a SQL Server 2016 SP1 CU4 instance). In Event Viewer, I find the following event from ".Net Runtime":
Application: Ssms.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.NullReferenceException
at Microsoft.SqlServer.Management.SqlMgmt.ScheduleDialog.InitializeControls()
at Microsoft.SqlServer.Management.SqlMgmt.ScheduleDialog..ctor(Microsoft.SqlServer.Management.SqlMgmt.JobScheduleData)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.ChangeShedule()
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintDiagramHostCtrl.grid_MouseButtonClicked(System.Object, Microsoft.SqlServer.Management.UI.Grid.MouseButtonClickedEventArgs)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnMouseButtonClicked(Int64, Int32, System.Drawing.Rectangle, System.Windows.Forms.MouseButtons)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.HandleButtonLBtnUp(Int32, Int32)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.ProcessLeftButtonUp(Int32, Int32)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnMouseUp(System.Windows.Forms.MouseEventArgs)
at System.Windows.Forms.Control.WmMouseUp(System.Windows.Forms.Message ByRef, System.Windows.Forms.MouseButtons, Int32)
at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)12 votesThis is fixed in the current version of SSMS, as it was mentioned below.
-
SSMS 17.6 Crash when opening scheduler task for a maintenance task
When conencting for far to
2012 sp3
2014 sp2
2016 sp1I crash anytime I try to open the scheduler task, I still had a VM with 17.4 and this works correctly on the same versions.
New or already created one. No time to enter or modify as it crash on load.
Event id 1000
Faulting application name: Ssms.exe, version: 2017.140.17230.0, time stamp: 0x5aa77b02
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc0000005
Fault offset: 0x15723a35
Faulting process id: 0x163c
Faulting application start time: 0x01d3c19109d5c915
Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe
Faulting module path: unknown …11 votesThis should be fixed in the current version of SSMS.
It’s a duplicate of https://feedback.azure.com/forums/908035/suggestions/33712924.
If you think it is not fixed (or you see something else wrong), please open a new UserVoice item and provide more detailed steps so we can investigate further. Thanks!
-
SSMS 18.4. Job properties window hangs when try to edit a step
SSMS 18.4. Job properties window hangs when try to edit a step
Using SQL 2016 SE SP2 CU1010 votesThis issue was fixed in SSMS 18.5
Thanks,
-Matteo -
Unable to horizontal scroll Results pane via mouse wheel in SSMS
My mouse has a horizontal scroll wheel. I can use the horizontal scroll in the Query pane, but if I select the Results pane, I can't scroll horizontally using my mouse. If I scroll to the left by dragging the scroll bar, and then try to use the horizontal scroll wheel on my mouse, the Results pane snaps to the leftmost position.
10 votesPlease, install SSMS 18.2 which has the fix.
Thanks,
-Matteo -
SSMS Extended Events UI Selects Actions on Hover
When selecting events in extended events session properties > events page the events are automatically selected when you hover your mouse over the row. I've attached a gif showing the behavior. I'm not clicking on anything in the gif, just moving my mouse.
9 votesThis issue was fixed in SSMS 18.5
Thanks,
-Matteo
- Don't see your idea?