Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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 Microsoft Q&A or Stack Overflow

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. [CONFIRMED] [BUG]: SSMS 18.2 = OK, 18.3.1 = BUG

    It turns out than in Windows 10 LTSC (haven't tried other versions) in SSMS 18.3.1 onwards up to 18.5, in the table designer, when you are creating a column and switch cell using the TAB key, Windows's beep sound effect plays.

    I can confirm this does NOT happen in SSMS 18.2, which is a bummer because I really want to stay on the edge and use the latest & greatest versions.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. SSMS, table designer, no intellisense on dataType

    When creating a new table using the graphical designer, I used to be able to be able to type letters and it would select the datatype that matches the closest (effectively dropping me down to the listItem). Additionally, after I name a column and I press the tab key to get to the dataType column, an audio alert is triggered as if the tab key created some error.

    This behavior started happening in 18.3.1, I have rolled back to 18.2 to get the desired behavior.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. SSMS 18

    When double clicking on an sql file, a new instance of SSMS 18 will start up, but the file never opens. This never happened when I was using SSMS 17.8. I'm running on Windows 10 OS.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Set the Maximum Size of the SQL Server Error Logs

    In SQL Server 2012 and later versions, you can use xpinstanceregwrite to set the maximum size of individual error logs. Please make this setting available via SMO, instead of having to use xpinstanceregwrite.

    Documentation for this feature can be found here: https://support.microsoft.com/en-us/help/2199578/how-to-manage-the-sql-server-error-log

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
  5. SSMS - Grid Results Background Colour

    Please can you fix the issue with the grid results background colour being ignored in SSMS? If you try and change the colour, it always stays at white. This bug has been around since SQL 2005!!! Surely it's just one line of code, "background.color=xxxx"? - How can you let this bug drag on for at least 11 years!! The dark themes in Visual Studio work perfectly, why can't we have this is SSMS?

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add support for storing UTF-8 natively in SQL Server.

    You can store Unicode data in SQL Server today, but only in UCS-2 encoding. In many environments, UTF-8 is the dominating encoding for Unicode data, and it is the default
    encoding for XML documents.

    Today UTF-8 applications must convert between UCS-2 and UTF-8 to retrieve and store
    data in SQL Server, which adds complexity and overhead to applications.

    Another issue is that for languages written in the Latin script, UTF-8 is a much more effective storage format, since most for characters in text, only one byte is needed.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Error in SSMS 18.5 setting baselines in Vulnerability Assessment

    When running Vulnerability Assessments in SSMS 18.5, then trying to set a result as baseline, we receive the following error. This occurs on multiple machines against a SQL 2016 database. It works correctly in SSMS 17.9

    TITLE: Microsoft SQL Server Management Studio

    VA1095 - Failed to set baseline. (Microsoft.SqlServer.Management.ThreatDetection)


    ADDITIONAL INFORMATION:

    One or more errors occurred. (mscorlib)


    Could not load file or assembly 'Microsoft.Azure.Storage.Common, Version=11.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. (DataSec.VA.Core.Baseline)


    BUTTONS:

    OK

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. function inlining

    In SQL Server 2019 function is marked as inlineable but it's not and query comes back with following error:

    Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.

    Looks like SQL Server 2019 doesn't properly identify if function is inlineable and throws error vs just not inline it.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Azure Data Studio notebook - how to reorder text and code blocks?

    Is there a way to change the order of text and code blocks? I see only ways to insert before and after existing blocks, but to move blocks to a different place?
    If this is not possible directly in Azure Data Studio: are there other tool to manage the order of blocks?

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. SSMS 18.1 issue

    When editing job step details
    (Open a job in Job activity monitor, go to Steps tab and edit job step),
    The SSMS hang and wait ~30-60 seconds before it opens the step details window.

    It happnes on every SQL engine I connect to, regardless the engine's version.
    It didn't happen on SSMS 17.9.

    My desktop is Windows 10 Enterprise 64bit.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  11. SQL 2019 CTP 2.4 Bug when querying a view which contains a [inline] scalar function which calls another [inline] scalar function.

    We are getting the following error in SQL 2019 CTP 2.4:

    Msg 596, Level 21, State 1, Line 1
    Cannot continue the execution because the session is in the kill state.
    Msg 0, Level 20, State 0, Line 1
    A severe error occurred on the current command. The results, if any, should be discarded.

    Turning off inlining for the database (ALTER DATABASE SCOPED CONFIGURATION SET TSQLSCALARUDF_INLINING = OFF), or redefining the functions using WITH INLINE = OFF fixes the issue.

    Is this a known limitation with inline functions? Or, could be this specific to our scalar functions?

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. After SSMS Update to v17.8.1 I get Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal

    Don't really use replication server, so I didn't think this fit into that category, but the update to SSMS certainly messed up something....

    After updating my SSMS from v17.7 to v17.8.1, I get the following error. I also have Visual Studio Professional v15.7.5 and SQL Server 2017 Developer Edition. Yesterday, uninstalled SSMS, repaired VS v15.7.5, and reinstalled SQL Server 2017 Developer, which took forever, but everything seemed to run fine. I was up and running and then I usually restart my machine when I leave and when I logged in this morning, I'm getting this error again (I'm assuming the…

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. SQL Management Studio Copy Database Wizard Broken

    Copy Database Wizard is not working for local copy operation. v17.5 There are previous bug reports when trying to copy a SQL201x -> SQL2017 DB using management studio 17.x . However, it appears you cannot copy a SQL2017-SQL2017 DB as well using the same wizard using the SMO option when copying without taking the DB offline. ERR: Property HasMemoryOptimizedObjects is not available for Database '[test]'

    File attached

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. Appending datetime to the end of ""Commands completed successfully ... 2018-03-05 09:28:10.1829207"

    When I make any change to a stored procedure & compile it (F5),
    besides just returning ...
    "Commands completed successfully."

    Could we append a datetime to the end of that please ?
    "Commands completed successfully ... 2018-03-05 09:28:10.1829207"

    Buddy

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  15. SQL Object Scripting "Check for object existance" doesn't work as desired in SSMS

    Ever since SSMS 2012, using this option has produced undesirable code. It worked fine in SSMS 2008 and 2008R2 and I would like some way to restore that functionality.

    When scripting out a view, I want the script to be:

    IF (view exists) DROP VIEW;

    CREATE VIEW blah blah blah;

    I want two steps: Drop and Create. And I want the generated script to run correctly whether or not the view is already there. (this applies similarly to triggers, stored procedures, functions, indexes, etc... anywhere you can script for 'drop and create').

    I loathe the current behavior of using either…

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. SSMS 8.7 - CREATE OR ALTER is not supported for type ExtendedProperty. (Microsoft.SqlServer.Smo)

    in object explorer, triggers, right click, use 'create or alter to', new query editor window, and get this error

    ===================================

    CREATE OR ALTER is not supported for type ExtendedProperty. (Microsoft.SqlServer.Smo)


    Program Location:

    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptCreateOrAlter(StringCollection query, ScriptingPreferences sp)
    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptCreateOrAlterInternal(StringCollection query, ScriptingPreferences sp, Boolean skipPropagateScript)
    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptCreateOrAlterInternal(StringCollection query, ScriptingPreferences sp)
    at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptAlterObjects(List1 urns, Boolean isCreateOrAlter)
    at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptUrns(List
    1 orderedUrns)
    at Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable1 urns)
    at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List
    1 urns, ISmoScriptWriter writer)
    at Microsoft.SqlServer.Management.Smo.ScriptMaker.Script(Urn[] urns, ISmoScriptWriter writer)
    at Microsoft.SqlServer.Management.Smo.ScriptMaker.Script(Urn[] urns)
    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ScriptGenerator.ScriptCreateAlter(SqlTextWriter sqlwriter, Server server, Urn[] urns, ScriptingOptions options)
    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ScriptNodeActionContext.Script(SqlTextWriter writer)
    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SqlScriptMenu.OnScriptItemClick(Object sender, EventArgs e)

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  5 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. Replication Monitor Crashing with SSMS 17.8.1

    I installed SQL Server Management Studio 17.8.1 last night. This is from the About box:

    Microsoft SQL Server Management Studio 14.0.17277.0
    Microsoft Analysis Services Client Tools 14.0.1016.262
    Microsoft Data Access Components (MDAC) 10.0.16299.15
    Microsoft MSXML 3.0 4.0 6.0
    Microsoft Internet Explorer 9.11.16299.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.3.16299

    This build has broken Replication Monitor. When I go to review the details of (for example) Distribution Agent Job Properties, it will crash with "Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal, Version=14.0.0.0"..... The located assembly's manifest definition does not match the assembly reference."

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. Make this uservoice usable

    • Searching removes the "top ideas" option
    • no subproduct or labelling (SSIS, SSRS, etc)
    • Search is useless "ssis text qualifier embedded" I want all keywords not results like "VS 2017 SSDT SSIS Dark Theme fail" which contains

    Unless it's by design?

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

SQL Server

Categories

Feedback and Knowledge Base