SQL Server

Microsoft SQL Server 2017 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 2017 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.

Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. binary or string data would be truncated => error message enhancments

    if you have that error (in production), it's not obvious to see which column or row this error comes from, and how to locate it exactly.
    it's even more complicated if it's coming from a trigger, for example, and not the original insert/update.

    I have seen that oracle meanwhile gives clear information which column the error is raising, which actual data length was passed, and the column's max size.

    1,156 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      completed  ·  95 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    • Give us option to not have square brackets when drag&drop in SSMS

      When we drag something from OE into a query window, then the identifier will always be enclosed in square brackets. Many of us do our due diligence and take care to use identifiers that do not require separators. These separators makes SQL code (a lot) harder to read, and we feel that we are punished with these square brackets. We don't want to do a search and replace all over and over again, when there could just be a setting in SSMS to not generate these.

      61 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        18 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
      • 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 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          12 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        • Add Default Backup Checksum Option to SSMS GUI

          SSMS should have a checkbox under Server Properties, on the Database Settings page, labeled something like "Use Backup Checksums" that would toggle the sp_configure setting for "backup checksum default". This would make it easier for people to enable backup checksum default, which is a good "best practice" that the tooling should encourage.

          21 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
          • 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 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
            • 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 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
              • SSMS 17.6 Crash when opening scheduler task for a maintenance task

                When conencting for far to

                2012 sp3
                2014 sp2
                2016 sp1

                I 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 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  10 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                • SSMS pop-up windows/forms on same screen where SSMS window is active.

                  When right clicking in the object explorer on an element, i.e., "Tables" and wanting to perform an action such as filtering tables by going to Filter > Filter Settings, the filter settings form can appear on the other screen than where SSMS is currently active -- which is quite distracting.

                  I believe this is due to the initial position of SSMS on startup. If you move the SSMS window to another screen, the opening of forms/windows etc. will remain on the original screen and not follow the main SSMS window.

                  Watch this clip: https://d.pr/v/v7dq8v
                  Notice that you can only see…

                  7 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                    • 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
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                      • SSMS error with SHOWPLAN_TEXT

                        When you enable the parameter "SET SHOWPLAN_TEXT ON; " The first query execution goes well and produces a query plan in text format, but the second one causes an error at the level of "mscorlib "

                        4 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                        • SSMS should not given an error when newsequentialid() used as a "default value or binding"

                          In SQL Server Management Studio 2008 RC0, when you enter "newsequentialid()" as the "Default Value or Binding", SSMS gives a dialog box that says "Error validating the default for column XYZ. Do you want to cancel your changes?"

                          This error message occurs whether or not you have set the RowGUIDCol property on the xolumn.

                          I have seen similar feedback items, mostly for SQL 2005, but there seems to have been no resolution in several years. I hope this can get fixed for SQL 2008.

                          4 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                          • SSMS 17.6 - Cannot schedule a maintenance plan while in creation, crashes the SSMS tool.

                            While creating a maintenance plan, click on the scheduler icon to create a schedule, the application crashes.

                            3 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                            • Error when adding case sensitive collation database to Availability Databases

                              When adding a database that has case sensitive collation to Availability Databases (SSMS -> Always On High Availability -> Availability Groups -> Group Name) it will fail with the following error: "The multi-part identifier "a.delimited" could not be bound".

                              3 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                              • Bug with SET SHOWPLAN_ALL ON

                                In Management Studio V17.4 me and my colleague both gets the error "Input string was not in a correct format. (mscorlib)" when we have first executed the SET SHOWPLAN_ALL ON statement and do a simple select like SELECT * FROM sys.objects afterwards

                                This works in SQL 2016, so something must be broken in SQL 2017

                                3 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                • SSMS 17.4 - Error when enabling page compression on index through GUI

                                  When trying to enable page compression on an index through the GUI (SSMS 17.4), I get the following error: "Object reference not set to an instance of an object".

                                  3 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • MSSQL 2014 SP2 CU10 KB4057307 fix broke something about a way M2M works with cache

                                    Dear Support,

                                    There is an issue in MSSQL 2014 SP2 CU10 fix of KB4057307: it breaks something in SSAS cache if M2M in cubes are used.

                                    Description of the problem and source of detected problem:
                                    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/cecbd6d5-69b8-4410-9c51-a791e6e2cf75/the-mdx-function-failed-because-current-coordinate-is-empty?forum=sqlanalysisservices&prof=required

                                    Symptoms: connecting to the cube, starting to receive messages "MDX function failed because current coordinate is empty".

                                    Solutions:
                                    1) temporary: clear cube cache (not a solution for production to clean cache during the day)
                                    2) roll back to CU9.

                                    There is a new CU11 available already.
                                    Question: is this cache issue that started in CU10 - fixed in CU11?
                                    Or for solution need to…

                                    2 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      completed  ·  4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Hi, can anyone tell me when security patches for the meltdown/spectre vulnerability will be made available within the Microsoft update catal

                                      Hi, can anyone tell me when security patches for the meltdown/spectre vulnerability will be made available within the Microsoft update catalog? I would like to push them down Via wsus but cannot do this due to them now being added into the catalog or wsus.

                                      KB4057121 for 2012

                                      KB4057113 for 2008 R2

                                      thanks

                                      Lee

                                      2 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                        • SSRS export to CSV does not respect Row Visibility

                                          The SSRS CSV renderer does not respect Row Visibility. So if a row in a tablix is suppressed with a Visibility expression, it does not export to other formats like PDF or Excel, but the row DOES export to CSV, so the data does not match up to what is on the report in other formats. BAD!

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            completed  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 21 22
                                          • Don't see your idea?

                                          SQL Server

                                          Feedback and Knowledge Base