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. Fix spelling error in template "Database Mail" > "Simple Database Mail Configuration"

    The word "specified" is spelled incorrectly of line 79 of the Simple Database Mail Configuration Template on SSMS 17.4.

    The line reads "RAISERROR('Failed to associate the speficied profile with the specified account (<account_name,sysname,SampleAccount>).', 16, 1) ;"

    2 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 →
  2. Option to specify the SSMS 2016 Installation Path

    The Installation of SSMS 2016 makes the Path Environment path very long. To get around it we would like to install it on a shorter path, but it looks like there is no option to specify the Installation Path like there was when SSMS was part of the SQL installation in SQL 2014.

    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 →

    This can be done with SSMS 18.
    Please download the Preview 5 and validate if you are able to do this.
    Also note that the install needs to happen via command line to install SSMS in a [non-C] folder.

    For instance, for culture = en-us, the install would look like:

    SSMS-setup-enu.exe SSMSInstallRoot=“X:/MySSMS”

    thanks,
    Dinakar

  3. There is insufficient system memory in resource pool 'default' to run this query

    SQL Server 2019 RTM responds with:
    Msg 701, Level 17, State 123, Line 1There is insufficient system memory in resource pool 'default' to run this query.

    while calling a simple scalar function that manipulates a single string.
    Example call: SELECT dbo.E164(NULL)

    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 →
  4. 18.4 is junk

    SSMS 18.4 is the most unstable software I've installed in a long time. It crashes constantly, hangs, memory hog, memory leaks, etc..

    My suggestion is for everyone to roll back to 17.9.1, which appears to be the most recent "stable" version, from my experience.

    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 →
  5. The SSMS setup is 18.3.1 instead of 18.4

    The setup is 18.3.1 not 18.4

    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 →
  6. 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 →
  7. sql-server-2019-ctp

    Installing sql-server-2019-ctp succeeded, but starting SQL Server Configuration Manager failed

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

    We’ll send you updates on this idea

    0 comments  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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 →
  9. SSMS 18.1 SQL Agent Job Step lost focus

    SSMS 18.1 SQL Agent Job Steps

    When deleting a job step, in previous versions of SSMS, the focus would remain at the place of deletion. eg. delete step 18, the step would be removed, then all steps move up and the new step 18 would be in focus. In SSMS 18 & 18.1 the focus returns to step 1 after deletion is time consuming when modifying jobs with large number of steps.

    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 →
  10. 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 →
  11. 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 →
  12. ssms 18.x not getting launched

    HI Team, I have installed SSMS 18.x when installed and launched it worked fine. After closing the app few time, when I am trying to launch it again its getting started and the window disappears even before launching the app. I could not find the app in the hidden tabs(Alt+Tab) even. I have tried to reinstall the app, even then this is the case. So raising this.

    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 →
  13. 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 →
  14. Good afternoon, please add the database diagrams, there are databases in which one works and they have diagrams, help to solve that, thank y

    Good afternoon, please add the database diagrams, there are databases in which one works and they have diagrams, help to solve that, thank you

    1 vote
    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 →
  15. cannot start 18 manager

    MS SQL Server Management Studio Release 18.0 can only start once after installation. The next time you start, you only see the logo for a very short time and nothing happens anymore.
    The program must first be uninstalled. After a new installation, it starts again only once.
    I'll test the SSMS version 17.9 next week
    It's a new Windows Server 2019 with SQL Server 2017.

    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 →
  16. 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 →
  17. Cannot disable intellisense

    Even with Intellisense disabled, intellisense is enabled when opening a new query window.

    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 →
  18. SSMS 18.0 doesn't script CREATE EXTERNAL LIBRARY properly

    I've tried to script all objects in a database using Tasks -> Generate scripts. The result was missing content and of course error 39044 during execution of the script on another instance:

    CREATE EXTERNAL LIBRARY [ml]
    FROM (content = &#39;&#39;)
    WITH (LANGUAGE = &#39;R&#39;)
    GO

    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 →
  19. 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 →
  20. SSMS 508 compliance

    Trying to determine 508 compliance for SSMS; any guidance available?

    1 vote
    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 →

    Our 508 Conformance documentation can be found the the following link
    https://celaaatprod.blob.core.windows.net/public/1e153b8b-985d-4b0e-9ef9-5fd4170e0c84/52e451a1-b639-4fbe-94ae-55de5d66e06c/SQL%20Server%20Management%20Studio%2018.Windows.RevisedSection508.docx

    This document along with those for other accessibility standards can also be reached by https://cloudblogs.microsoft.com/industry-blog/government/2018/09/11/accessibility-conformance-reports/ and searching for “SQL Server Management Studio”

    Thank you for reaching out,
    Erica

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base