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.

More details about SQL Server are available in the SQL Server documentation.
If you have a technical issue, please open a post on the developer forums through Stack Overflow or MSDN.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. SSMS 18.0 doesnt opens, splash screen ends with a Sound

    SSMS 18.0 doesn't opens, splash screen ends with a sound.
    Repair setup doesn't fix it.
    Issue is fixed after reinstalling SSMS. but reappears after some days.
    Windows Event Logs doesn't show any errors, pls confirm from where to find any logged errors for SSMS.

    Windows 10 Enterprise 1809 OS Build 17763.437
    Visual studio Enterprise 2019 16.1.1
    Visual studio Enterprise 2017 15.9.12

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. SQL Server Management Studio 18 is not opening just a splash screen pops up.

    SSMS 18 is worked for few days (4-5) and from today just a splash screen pops up.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSMS 18.1 still missing status bar colors

    I posted this bug in the early betas and requested it again to be fixed after GA release but in 18.1 there is still no change.

    The query status bar in SSMS 17 and older has been khaki for single server connections and pink for group connections. There is no color for either type in SSMS 18 and going into options and setting it to khaki and pink values is not retained after closing the app. This is very important indicator as a quick confirmation that I'm not in a milti-server query window before executing.

    Tools -> Options -> Text…

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Restore CTRL-D shortcut for ResultsToGrid in SSMS

    In SSMS 18 Preview 4, the default binding have changed to Edit.Duplicate lines, quoting https://feedback.azure.com/forums/908035-sql-server/suggestions/32896594 as a the motivation.

    CTRL-D has been bound to ResultsToGrid, for almost 20 twenty years (that is since Query Analzyer came out in SQL 7.) That is engraved in many people's minds.

    Yes, I can change the key binding, but so can people who prefer to use it to duplicate lines.

    Please restore the original default. It does not serve the community to change existing bindings.

    30 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  4 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. Serious Issue: After Closing, SQL Will Not Open Without Reinstalling Entire Program

    I have already tried working with Microsoft Support four separate times on this but nothing thus far has provided anything beyond a temporary fix. I can open SQL once I install the program, but once I close it I need to reinstall the program to open it again. I have been having issues with another unrelated program since April but have been using SQL since late May, so I have no idea if the two problems are related (I suspect they are).

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. ADD SENSITIVITY CLASSIFICATION statement support for SSDT

    Azure SQL Vulnerability Assessment will identify columns in the database that should be classified as sensitive. One can do this in SSMS with a simple ADD SENSITIVITY CLASSIFICATION statement.
    BUT, one CANNOT make such a statement in SSDT database project, even if the target version is Azure SQL V12.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. Select All option for File Import Wizard

    The Flat File Import Wizard should have a Select/Unselect All option on Allow NULLs

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Incorrect GrantedQueryMemory(KB) Value on SQL Performance Dashboard or SSMS17.9

    The inbuilt SQL Dashboard within newer versions of SSMS displays report for GrantedQueryMemory(KB) column for current request sub report. The value displays the wrong number as output displayed is in bytes while column says KB.

    I have verified using the dmv "sys.dmexecquery_stats" which lists this number in no.of pages which later is converted to KB

    When checking within rdl file we can see that conversion is made with expression as =8192 * Fields!grantedquerymemory.value which gets this value in bytes.

    Therefore we might need to change that expression to = 8 * Fields!grantedquerymemory.value

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. SSMS Flat File Import is not working for SSMS 18.1 upgrade

    When upgrading SSMS 18.0 to 18.1, the Flat File Import is no longer importing csv, tab delimited or other delimited files.

    Procedure:


    1. Open SSMS 18.1, select any database to import to.

    2. Right click | Task | Import Flat File

    3. When presented by the file browse of the Wizard, navigate to where the attached (test_csv.txt) and load

    4. The attached (flatfileimport_error.png) appears.

    note: This looks to be happening in my machine, as a fresh install SSMS 18.1 instead of an update on a different machine works.

    Attached:
    flatfileimporterror.png - screenshot of error
    test
    csv.txt - sample csv…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. Can't Install SSMS 18 with Visual Studio 2019

    Installing SSMS 18 GA will fail if Visual Studio 2019 has been installed, as the former requires Visual Studio Tools for Applications 2017, which will not install if the latter is already installed.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. Reimplement ERD Diagrams in (SSMS18)

    ERD Diagrams are basically needed to check the structure (visual) of a database. it was a key component of SSMS. Why would you even remove it and force us to install another 3rd party app, while SSMS is already a bloatware on itself...

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  13. There is no Database Diagram in SSMS 15.0.18075.0. Does anyone know what happened? Thanks.

    There is no Database Diagram in SSMS 15.0.18075.0. Does anyone know what happened? Thanks.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. Migrating data from say 2017 SQL Web edition to SQL Standard. Any limitations?

    For one of our projects we were hoping to use the 2017 MS SQL web edition for pre-production(DEV, UAT, QA etc) and post-QA testing migrate the data, stored procedures/scripts to STD edition in production. Involves one big push initially and then with every release smaller data being pushed. Are there any limitations or compatibility issues we can run into?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    41 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. Microsoft.AnalysisServices.Deployment.exe not in ssms 2018

    It appears that the deployment utility for SSAS is not included in the latest release of SSMS 18. Are there plans to include it or is this being ported over to ssdt?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. SSMS 18.1

    SSMS 18.1 has a bug in restoring databases from UNC folders

    Repro:
    - Object Exploere right click restore database
    - Source: Chose Device and Press ...
    - Press Add
    - Enter a UNC path into the field Backup File Location and press Enter

    In the older versions (17.x and older) the dialog showed the content of the UNC folder. Now nothing happen.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. Don't deprecate database diagrams.

    I design large scale databases visually with the diagram feature of SQL server. I cannot comprehend how a db designer would tackle a large scale ER model. What is the reason for the deprecation and what is the planned alternative?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  19. SSMS 18.0 Preview 7 - Job Properties Window ArgumentOutOfRangeException

    The IDE crashed while working with a Job Properties window.

    Application: ssms.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.ArgumentOutOfRangeException
    at System.Collections.ArrayList.get_Item(Int32)
    at Microsoft.SqlServer.Management.UI.Grid.MemDataStorage.GetRow(Int32)
    at Microsoft.SqlServer.Management.UI.Grid.MemStorageView.GetCellData(Int64, Int32)
    at Microsoft.SqlServer.Management.UI.Grid.DlgStorage.GetCell(Int64, Int32)
    at Microsoft.SqlServer.Management.UI.Grid.DlgStorage.OnCustCellGDIObjects(System.Object, Microsoft.SqlServer.Management.UI.Grid.CustomizeCellGDIObjectsEventArgs)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.GetCellGDIObjects(Microsoft.SqlServer.Management.UI.Grid.GridColumn, Int64, Int32, System.Drawing.SolidBrush ByRef, System.Drawing.SolidBrush ByRef)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.PaintOneCell(System.Drawing.Graphics, Int32, Int64, Int32, Int64, System.Drawing.Rectangle ByRef, System.Drawing.Rectangle ByRef, System.Drawing.Rectangle ByRef)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.PaintGrid(System.Drawing.Graphics)
    at Microsoft.SqlServer.Management.UI.Grid.GridControl.OnPaint(System.Windows.Forms.PaintEventArgs)
    at System.Windows.Forms.Control.PaintWithErrorHandling(System.Windows.Forms.PaintEventArgs, Int16)
    at System.Windows.Forms.Control.WmPaint(System.Windows.Forms.Message ByRef)
    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)

    Faulting application name: ssms.exe, version: 2019.150.18092.0, time stamp: 0x5c772f01
    Faulting module name:…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base