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. 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 →
    • 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.

      14 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 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 →
          • 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 →
                        • SQL 2017 SSRS / Analysis Services management packs for SCOM?

                          Although SQL Server 2017+ (Windows and Linux) management packs for SCOM exist, there seems to be no SQL Server 2017 Reporting Services (Native mode) or SQL Server 2017 Analysis Services management packs for SCOM available yet. When will this be rectified? (See MP wiki screenshot - all other SQL versions have AS/SSRS management packs).

                          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

                            2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                          • Option to disable Reporting Services 2017 telemetry

                            It does not appear to be possible to disable telemetry that is part of Reporting Services 2017 (version 14.0.600.689) via Microsoft.ApplicationInsights.dll. The cookies ai_user and ai_session are set and requests initiated to MS-owned cdn web pages.

                            Options that exist for the independently distributed ReportViewerControl (available via NuGet) do not appear to apply to Standalone SSRS 2017.

                            I am also using a custom Forms authentication setup.

                            See also https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e6fd0eb7-2e6a-4818-a1bc-d18d3be89e73/how-to-disable-telemetry-for-ssrs-2017?forum=sqlreportingservices.

                            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

                              2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                            • SQL Server 2017 on Linux System Databases Rebuild Option

                              For the longest time I've been running SQL Server 2017 GA in Ubuntu 17.10. But, recently, after a recent apt update/upgrade to the OS, it stopped working.

                              I can't find any documentation to rebuild the system databases as the message I'm getting from the log in the image provided.

                              It would be nice to have an option as "/ACTION=REBUILDDATABASE".

                              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

                                1 comment  ·  Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →
                              • Query returns all rows when subquery fails

                                If subquery fails with
                                "Msg 207, Level 16, State 1, Line 16
                                Invalid column name"
                                all data is returned from the outer query.

                                if object_id('justnow','U') is not null drop table justnow
                                if object_id('string','U') is not null drop table string
                                go

                                select getdate() somedate
                                into justnow
                                go

                                select 'xyz' txt
                                into string
                                go

                                select *
                                from justnow
                                where somedate in (select somedate from string)
                                go

                                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  ·  2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                • Exception calling "Deploy" with "3" argument(s): "Object reference not set to an instance of an object."

                                  I'm getting this error when deploying a dacpac using the nuget version of DacFx.

                                  The dacpak in question is very simple - one sproc, one table, a pre and post script (both empty).

                                  This deploys fine if I use either sqlpackage.exe (17.4.0 GA DacFx) or Visual Studio Data Tools 2017 (latest version). It is just an issue with the library.

                                  (Full stack trace and sample Powershell code in attachment)

                                  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

                                    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Why must one perform a full backup to add to an AG, when the wizard does a full backup?

                                    When adding a database to an availability group, one must perform a full backup, before meeting the prerequisites.
                                    However, once you do this, the wizard just performs another full backup anyway.
                                    This seems redundant.
                                    Why not just let the wizard do this, and not make it a requirement, as it's going to happen anyway?

                                    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

                                      1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 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

                                        0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

                                        We take a number of inputs into consideration when triaging issues. Business impact (severity of the issue) as well as Votes (or likelihood of a customer being impacted) are just two of the factors we consider when triaging.

                                        We do not simply use votes alone.

                                      • Incomplete result set is returned when column schema for a table is requested via ADO and the table contains columns having dot in

                                        On SQL Server 2008 (SP1), when a column name contains the dot character, it is not included in the schema rowset of the respective table when requested via both the SQLOLEDB and SQLNCLI10 providers using ADO's OpenSchema(adSchemaColumns) method. The SQL Server Profiler shows that a command similar to the following is issued on the server:

                                        [testdb].[sys].sp_columns_100_rowset N'tab',N'dbo',NULL

                                        When executed, this command returns rows for all columns except those which contain the dot character in their name. On SQL Server 2005, it works as expected.

                                        Ales

                                        0 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  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Connection Properties are not retained when servers are registered under a Central Management Server

                                          Connection Properties are not retained when servers are registered under a Central Management Server.

                                          I have tested the "Connect to database:" and "Use custom color:" properties and neither retain there settings after reconnecting to or refreshing the Central Management Servers. I would expect that these settings would be stored on the CMS to enable setting these properties centrally for consistency.

                                          0 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  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 20 21
                                          • Don't see your idea?

                                          SQL Server

                                          Feedback and Knowledge Base