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. Manual failover without data loss not working in SQL2019

    We have setup two Linux SQL2019 CU3 instances on Ubuntu with HA enabled and I get an error when I execute: ALTER AVAILABILITY GROUP [ag6x52] SET (ROLE = SECONDARY); to manually failover over to the secondary replica.

    The message is:
    Msg 41104, Level 16, State 5, Line 1
    Failover of the availability group to the local replica failed because the availability group resource did not come online due to a previous error.

    My AG is as follows

    Create AVAILABILITY GROUP ag6x52
    WITH (CLUSTER_TYPE = NONE )
    FOR REPLICA ON
    N'sql52' WITH (

      ENDPOINT_URL = N'tcp://172.16.6.52:5022',
    
    AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,
    FAILOVER_MODE =
    8 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. BCP always adds a row delimiter after 2022 chars and has a bug when declaring an empty row delimiter

    There are a couple of bugs in BCP that don't allow you to extract a proper formatted JSON (or XML) file. In details:


    • BCP always adds a row delimiter after 2022 chars

    • BCP uses 63.502 white spaces (0x20) as row delimiter using -c if you pass an empty row delimiter (-r). So you'll find 63.502 white space after 2022 chars and at the end of the string.

    • BCP uses 63.502 combinations of chars 0x20 and 0x00 as row delimiter using -w if you pass an empty row delimiter (-r). So you'll find 63.502 white space after 2022 chars and at…
    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. when i switched between tabs, new tab still show previous tab text. Please fix asap

    when i switched between tabs in SSMS 18.4, new tab still show previous tab text. Please fix asap

    8 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 →
  4. SSMS 18.x freezes when view job properties

    We use multiserver administration forour SQL Agent jobs and when attempting to view any jobstep properties of managed jobs while connected to a target server using SSMS 18.x, the program freezes for up to two minutes.

    SQL Server Management Studio 15.0.18142.0
    Microsoft Analysis Services Client Tools 15.0.1389.0
    Microsoft Data Access Components (MDAC) 10.0.14393.0
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer 9.11.14393.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.14393

    8 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 →
  5. CREATE OR ALTER is not fully supported in Transactional Replication DDL commands

    We've been having trouble with some objects not replicating correctly after a DDL change.

    When a published function or proc is altered, the following appears to happen:
    A database trigger is called: trMStranalterschemaonly
    Which calls a proc called: sys.spMStranddlrepl - This proc will output debug IF MSrepldebugDDL exists (create anything called this!)
    which calls a function: master.sys.fn_replgetparsedddlcmd, which is designed to return the ddl after the object's name, to be used for generating the command to be applied 
    at the subscribers.

    SQL Server BOL states that ALTER is supported (https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/replicate-schema-changes?view=sql-server-2016)

    However, this doesn't…

    8 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 →
  6. Remote harden of transaction '...' (ID ...) started at ... in database '' at LSN (...) failed.

    On SQL Server 2016, now even on two versions, the same error message can be seen while AG failovers either fail, or the after failover secondary replica has their databases in REVERTING / IN RECOVERY state.

    Example of these error messages
    Remote harden of transaction 'IFTSAutoNested' (ID 0x00000000141b98bf 0000:1d20f419) started at Feb 19 2019 11:16AM in database 'DB4' at LSN (93341:183352:3) failed.

    Remote harden of transaction 'INSERT' (ID 0x00000000141b989c 0000:1d20f418) started at Feb 19 2019 11:16AM in database 'DB4' at LSN (93341:183346:17) failed.

    Versions:
    13.0.5026.0
    &
    13.0.5237

    Two of such occurences have now appeared on dba.stackexhange.

    https://dba.stackexchange.com/questions/230128/always-on-availability-groups-resolving-state-after-failover-remote-harden-of

    https://dba.stackexchange.com/questions/230663/availability-group-database-stays-in-reverting-for-too-long-after-a-failover?noredirect=1#comment455408_230663

    Kind regards,

    8 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 →
  7. SQL 2016 Server Agent does not read Windows Credential when running a job step with Proxy

    When running an SSIS package to copy files to Azure File Storage, a Windows Credential is used with the Azure credential information to be able to authenticate. This works fine in Visual Studio, and when executing package manually through SSISDB when deployed to server - but not when executed through SQL Server Agent using a proxy. The proxy credential have the correct Windows Credentials provided using cmdkey. The package execution fails with "The file name specified in the connection was not valid". Both UNC and drive mapping variant fails.

    A similar problem here:
    https://stackoverflow.com/questions/46497728/sql-server-agent-untrusted-domain-message/46567995#46567995

    And here:
    https://stackoverflow.com/questions/52228418/ssis-package-not-picking-up-configured-windows-credential-manager-credentials

    8 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 →
  8. Management Studio Object Explorer Details sorting by name with folders on top

    By default, Object Explorer Details view sorts folders on top and then objects alphabetically by name. If name is selected to change the sort order, folders are then mixed in and there is no way to restore the default behaviour.

    8 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 →
  9. SSMS graphical execution plan doesn't show IsNotNull seek predicate

    The IsNotNull node under the SeekKeys node of execution plan XML is not being displayed at all in the graphical execution plan for an Index Seek. This makes it look like the IS NOT NULL portion of the predicate is being ignored unless you look at the XML.

    SentryOne Plan Explorer correctly parses and displays the IsNotNull node - see the attached screenshot pe-vs-ssms.PNG. That's hovering over the Index Seek operator for the same execution plan in both tools.

    The problematic XML looks like this in my example query:

    <SeekKeys>
    
    <Prefix ScanType="EQ">
    <RangeColumns>
    <ColumnReference Database="[StackOverflow2010]" Schema="[dbo]" Table="[Comments]" Alias="[c]" Column="PostId" />
    8 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. Fix merge bug on temporal history tables with indexes

    Fix bug in temporal tables where indexes on history tables result in the error: Attempting to set a non-NULL-able column's value to NULL when an MERGE is performed. Exact steps to replicate can be found here:
    https://social.msdn.microsoft.com/Forums/en-US/f4fbdfcc-c10e-4412-8011-2bbd3cdda5eb/merge-on-temporal-table-fails-with-attempting-to-set-a-nonnullable-columns-value-to-null?forum=sqldatabaseengine

    8 votes
    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 →
  11. Make Central Management Server remember Azure Integrated authentication for Azure SQL DB

    In SSMS 17.8.1 we have a number of Azure SQL DB instances registered in our CMS.

    Everytime we re-open SSMS the CMS switches the authentication method back to "Windows Authentication"

    Manually switching back to "Azure - Integrated" works, but this option should be persisted and remembered in the CMS.

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

    We’ll send you updates on this idea

    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. SQL Server 2016 SP2 CU1 deletes Database Mail file

    Installing the above mentioned CU deletes this file...

    C:\Program Files\Microsoft SQL Server<instance>\MSSQL\Binn\DatabaseMail.exe.config

    It results in Database Mail being queued but never sent.
    This appears to be a return to an issue caused by SP1 CU1, as described here...

    https://support.microsoft.com/en-us/help/3186435/fix-sql-server-2016-database-mail-does-not-work-on-a-computer-that-doe

    To fix, follow the workarounds in the article. Hopefully this latest CU hasn't broken anything else!

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

    We’ll send you updates on this idea

    6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. SQL Server Azure - Bulk Insert to temp table fails when running under user other than sysadmin

    Bulk insert to a temporary table in SQL Server azure from an Azure blob only seems to work when running under the sysadmin account.

    The following scenarios describe the situation:
    - non sysadmin user into permanent table : works OK
    - non sysadmin user into temp table : doesn't work - Msg 4834, Level 16, State 1, Line 31
    You do not have permission to use the bulk load statement.
    - sysadmin user into permanent table: works OK
    - sysadmin user into temp table: works OK.

    This is a little frustrating as it means we need to use the sysadmin…

    8 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 →
  14. 8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. 'Windows API call "RegGetValueW"' error when displaying version in SQLLocalDB Utility 2016 and newer

    When using the "v" switch for the SQLLOCALDB command-line utility, it can only display versions 2012 and 2014. Starting with SQL Server 2016, the utility can no longer display installed versions of SQL Server Express LocalDB.

    In a command prompt, if I run the following:

    C:>sqllocaldb v

    It returns the following (and I have versions 2012, 2014, 2016, and 2017 installed, running on Windows 10 Home Edition):

    Microsoft SQL Server 2012 (11.0.7462.6)
    Microsoft SQL Server 2014 (12.0.5214.6)
    Windows API call "RegGetValueW" returned error code: 0.

    The SQL Server 2017 version of SQLLOCALDB.EXE is being used, as indicated by the first…

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

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  16. Opening Schema Compare Options crashes SSDT

    I open a saved schema comparison and press the arrow in front of "Application Scoped" on the "Object Types" tab. This makes SSDT crash immediately.

    Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT)
    Version 15.6.6
    VisualStudio.15.Release/15.6.6+27428.2037
    Microsoft .NET Framework
    Version 4.7.02556
    SQL Server Data Tools 15.1.61801.210
    Microsoft SQL Server Data Tools

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. Error with Detail Rows Expression when used with Excel drillthrough

    With a SSAS Tabular model on compatibility Level 1400, I have defined a Default Rows Expression to allow the client to obtain specific columns when connecting with an Excel pivot table but in Excel 2016 the following error is returned when the drillthrough is executed:

    "RETURN clause cannot be used with the DRILLTHROUGH statement when a DetailRows expression is already defined on the measure 'Transaction Count'"

    I have defined the Default Detail Rows Expression at the table level and have not defined a Detail Rows expression on any measures individually. My understanding is that if no expression is defined on…

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

    We’ll send you updates on this idea

    under review  ·  6 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. SQL Server should not raise illogical errors

    You already have tons of these bug reports, and I bet that you have closed them all "by design" and told people to use the CASE statement. But, no, you are wrong. This is a bug, and should be fixed. Although the fix is to add new functionality, hang on.

    Consider this silly repro:

    create table albert(a int NOT NULL,

                        b varchar(23) NOT NULL)
    

    create table stina (a int NOT NULL)

    go
    insert albert (a, b)

       values  (1, '99'), 
    
    (2, 'Gurka'),
    (3, '89')

    insert stina (a) values(1), (3), (9), (12)
    go
    SELECT a.a, a.b + 100

    FROM albert a
    JOIN…

    8 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 →

    Upvotes: 82

    <=-=Mar 3 2010 10:44AM=-=>

    Hi Erland,
    Thanks for your feedback. We are aware of this request and hope to address it in a future version of SQL Server.


    Umachandar, SQL Programmability Team

    <=-=Jul 21 2010 5:36PM=-=>

    This bug cost me and others about 8 hours of troubleshooting this week. And the query was working until statistics were updated. That’s the spooky part, that a new join order can cause an error in a previously-working query. This was compounded by the fact that the query was in a UDF and 1) error messages don’t list the line in the UDF but rather the calling SP and 2) I know of no way to see the execution plan of a UDF, which would have helped because I could have seen in the plan the conversion to float before the JOIN to the filtering table.

    <=-=Mar 9 2011 12:08PM=-=>

  19. SSMS / Management Studio shows wrong decimal separator

    When the regional settings of the computer has , as decimal separator, management studio will use it to format float -columns, but for decimal(x,x) it still uses . instead. This is quite annoying since . is used as a separator in dates, so copying data into excel tries to turn numbers into dates.

    This same issue exists at least in all versions from 2005 up to 2016 CPT2. I think there was a connect item for this earlier too, but I can't find it anymore.

    8 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 →
  20. SSRS 2016 Report Descriptions missing in report manager tiles

    In the new report manager which came SQL Server 2016 i'm missing the report description in the tiles.

    In our environment we used this field as a user friendly report name and the report name property as just a code. This way we could easily link to existing reports and never have to worry about changing report names, but without the descriptions the users won't know which report they must open.

    8 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 →

    Upvotes: 8

    <=-=Oct 19 2016 4:13PM=-=>

    Thanks for your feedback Mark. A change for this is coming with SQL server 2016 SP1.

    -SSRS team

    <=-=Oct 19 2016 4:13PM=-=>

    Thanks for your feedback Mark. A change for this is coming with SQL server 2016 SP1.

    -SSRS team

    <=-=Jan 24 2017 3:17PM=-=>

    We have an SSRS 2016 SP1 Developer Edition instance running in native mode, and we still do not see descriptions on the report tiles.

    <=-=Aug 1 2017 1:39AM=-=>

    We are using SQL server 2016 SP CU3 and I don’t see any description on my reports, do you know if the change have been done ?

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base