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. SSMS 18.1 Crashes when Opening a Database Diagram

    SSMS 18.1 crashes (and restarts) when opening a database diagram without any error message.

    I have created several diagrams from scratch thinking it might have to do with old formatting, but this does not appear to be the case.

    You can edit a diagram (adding dozens of tables) with no problem. It is the opening of the diagram that results in the crash.

    Latest bits for SSMS and SQL Server 2017 installed today.

    SQL Server Management Studio 15.0.18131.0
    Microsoft Analysis Services Client Tools 15.0.1347.0
    Microsoft Data Access Components (MDAC) 10.0.18362.1
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer 9.11.18362.0
    Microsoft .NET…

    1,194 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    649 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. bug - string_agg on external table results in "An error occurred while executing GlobalQuery operation: 100001;"

    string_agg on external table results in "An error occurred while executing GlobalQuery operation: 100001;Failed to generate query plan."

    declare @colList varchar(max) = ''
    select @colList=stringagg(quotename(colname), ',
    ') from dbo.external
    table --external table

    on "Microsoft SQL Azure (RTM) - 12.0.2000.8 May 15 2020 00:47:08 Copyright (C) 2019 Microsoft Corporation "

    16 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 →
  3. SSMS 15.0.18330.0 import bacpac failed

    With the latest SSMS 15.0.18330.0 I'm unable to restore an Azure SQL Bacpac, error is triggered when "Importing datase".

    If I try to get more details (clicking on the "Error" link), I get an NRE :

    TITLE: Microsoft SQL Server Management Studio

    Object reference not set to an instance of an object. (Microsoft.Data.Tools.Schema.Sql)

    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentPlanGenerator.DeploymentScriptDomGenerator.GenerateFragment(Int32 operation, IModelElement element)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentPlanGenerator.DeploymentScriptDomGenerator.GenerateSteps(Int32 operation, IModelElement element)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.OrderedStepGenerator.Add(DeploymentScriptDomGenerator scriptDom, IModelElement element, Int32 operation)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.Analyzers.PlanMediator.BuildDependencyOrderedSteps(Int32 operation, List1 classOrder, List1 operationOrder, Dictionary2 changes, Boolean preserveGraphs, Dictionary2& relating, Dictionary2& related)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.Analyzers.PlanMediator.BuildOperations()
    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentPlanGenerator.OnGeneratePlan()
    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentPlanGenerator.GeneratePlan(List
    1 drops)
    at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.BuildPlan() …

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

    We’ll send you updates on this idea

    8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Update on this one (admittedly, I dropped the ball on it – my apologies).

    Thanks François for the e/mail. I passed the info to the DacFx Team, when I received it).

    I have reminded them about this issue moments ago and they are looking into it.

    Thanks,
    -Matteo

  4. GROUPING SETS returns incorrect results

    The Query

    SELECT Surname,
    
    LEFT(Surname,1) AS SurnameInitial,
    COUNT(*) AS Count
    FROM Queen
    GROUP BY GROUPING SETS ( ( Surname ), (LEFT(Surname,1)) )

    Does NOT return the same results as the expanded version

    SELECT Surname,
    
    NULL AS SurnameInitial,
    COUNT(*) AS Count
    FROM Queen
    GROUP BY Surname
    UNION ALL
    SELECT NULL AS Surname,
    LEFT(Surname,1) AS SurnameInitial,
    COUNT(*) AS Count
    FROM Queen
    GROUP BY LEFT(Surname,1)

    Details here https://dba.stackexchange.com/a/267196/3690

    15 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 →
  5. SSMS 18.4 SQLServer 2019 CU2 Object explorer fails for SQLAgent

    After applicting CU2 on SQLServer 2019, SSMS18.4 fails to show SQLAgent jobs via object browser.

    TITLE: Microsoft SQL Server Management Studio

    Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476


    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


    A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.4013&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476


    BUTTONS:

    OK

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

    We’ll send you updates on this idea

    8 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. SQL Server 2019 scalar functions fail incorrectly if they have a CHECKSUM

    Scalar functions with CHECKSUM(*) fail on compatibility level 150, SQL Server 2019 build 15.0.4043.16.

    ALTER DATABASE CURRENT SET COMPATIBILITY_LEVEL = 140;
    GO

    CREATE OR ALTER FUNCTION dbo.Test()
    RETURNS INT AS
    BEGIN

    DECLARE @i BIGINT;
    
    SELECT TOP 1 @i = CHECKSUM(*)
    FROM master.dbo.spt_values;
    RETURN 1;

    END
    GO
    SELECT dbo.Test(); / Works fine /

    ALTER DATABASE CURRENT SET COMPATIBILITY_LEVEL = 150;
    GO

    SELECT dbo.Test();

    /* Gets error:

    Msg 1789, Level 16, State 1, Procedure Test, Line 6 [Batch Start Line 17]
    Cannot use CHECKSUM(*) in a computed column, constraint, default definition, or INSERT statement.

    */

    7 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 →
  7. Error when connecting to SSAS via msmdpump.dll in SSMS 18.5

    Hi,

    We have an SSAS instance with https access configured via msmdpump.dll. In 18.4 connection works fine, but in 18.5 it gives following error:

    Cannot connect to https://myserver/OLAP/msmdpump.dll.


    ADDITIONAL INFORMATION:

    String reference not set to an instance of a String.
    Parameter name: s (mscorlib)


    Could you check what is the reason?

    11 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 →
  8. Replication Monitor no longer automatically connects to publisher in 18.5

    Since upgrading to SSMS 18.5, replication monitor no longer automatically connects to the publisher. I have to manually go into the publisher properties every time and manually connect. SQL Server 2016.

    7 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 →
  9. msodbcsql on Linux does not work with CP932

    Latest version 17.5.2.1 of msodbcsql on Linux does not work with CP932.
    It worked with 17.4.1.1 before upgraded to 17.5.2.1

    We want to use the latest version of the driver, but Japanese charctors corruption is one of the big blokking issue to keep update.
    If this issue can't be fix, we can't upgrade anymore. It means we can't use new feature and fix, also supportability issue also happen because of old version in the future.
    That's why we really urge to have a chance to verify if the charactors also work before the relase new version.
    Here is the detail…

    6 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. SQL Server 2019: Seeing a lot more SCH_M locks vs same load on SQL 2017.

    Went to SQL 2019 on multiple servers and we are seeing a lot more blockings. Lock type is SCHM. We are seeing where 2 selects are involved and blocking each other with SCHM lock taken. We stayed on compatibility level of 140 due to some bugs in 150.

    waitresource="METADATA: databaseid = 61 METADATACACHE($hash = 0x2284b6b:0x0), lockPartitionId = 0"

    transactionname="CMEDCacheEntryFactory::FindOrCre"

    lockMode="Sch-M"

    2 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. Using SQL Azure: DateTime2 comparison on timestamp_utc for the fn_xe_telemetry_blob_target_read_file function does not seem to function corr

    Using SQL Azure: DateTime2 comparison on the [timestamputc] file for the sys.fnxetelemetryblobtargetread_file function does not seem to function correctly.

    If I query for data in the current century, nothing is returned - I only get data when I ask for data in the distant past.

    2 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 →
  12. 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 →
  13. 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 →
  14. SSMS 18.4 left and right arrow keys don't work in criteria pane

    When focused in a box in the criteria pane, the left and right arrow keys don't work. They have worked in previous iterations and up and down arrows still work.

    11 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 →
  15. Allow me to turn off the "Generate scripts" dialog that shows up whenever I alter an object to a new query window

    Sometime between 18 and 18.5.1, there was a new dialog box added, and it's slowing me down. Whenever I want to edit a procedure, function or view, I right-click in the object explorer and pick "Script ... as" > "Alter to" > "New Query Editor Window." Now, when I do that, I get a dialog box titled "Creating script for ..." that shows details on the progress of that generation. In the past, it was fast - with the addition of this dialog box, it's much slower.

    I looked for a preference to turn it off, but couldn't find one.

    2 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 →
  16. SSMS v18.5.1 Object error when using Import Flat File

    When importing a file via the Import Flat File an Object Error is raised if the file is open in another application. The error does not mention that the file is opened or in use.

    On Screen Error:

    TITLE: Microsoft SQL Server Management Studio

    Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import)


    BUTTONS:

    OK

    Stack Trace

    Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import)


    Program Location:

    at Microsoft.SqlServer.Prose.Import.BcpProcess.set_UseSimpleDataType(Boolean value)
    at Microsoft.SqlServer.Import.Wizard.PreviewPageController.OnActivate()
    at Microsoft.SqlServer.Management.TaskForms.SqlWizardPageController.OnFirstActivate()
    at Microsoft.SqlServer.Management.TaskForms.SqlWizardPageController.Microsoft.SqlServer.Management.TaskForms.ISqlWizardPageController.SetActive()
    at Microsoft.SqlServer.Management.TaskForms.ControllerPage.OnSetActive()
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.ActivatePage(NavigationItem item, NavigationDirection direction)
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.ActivatePage(Page page, NavigationDirection direction)
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.GoToPage(Page page)
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardFramework.OnNext()
    at Microsoft.SqlServer.Management.SqlWizardFramework.WizardButtonsPanel.OnNext(Object…

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

    We’ll send you updates on this idea

    planned  ·  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. Import Data New SQL client When selecting SQL Dataclient the database name is not visible

    The text message which is empty below the combobox blocks the database dropdown to be seen.
    Also previously I tought when selecting Import data.. that by default it always was on SQL Dataclient

    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 →
  18. bcp -G Option not working as described

    Description:

    Azure Active Directory Integrated

    For Azure Active Directory Integrated authentication, provide the -G option without a user name or password. This configuration assumes that the current Windows user account (the account the bcp command is running under) is federated with Azure AD.

    This is not working. If you don't provide a username: you get the error:

    SQLState = FA004, NativeError = 0
    Error = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Failed to authenticate the user '' in Active Directory (Authentication option is 'ActiveDirectoryIntegrated').
    Error code 0x800401F0; state 10
    CoInitialize has not been called.

    If you provide user and password…

    4 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 →
  19. Enable SSIS Double Hop authentication to work with Windows Defender Credential Guard

    Windows Defender Credential Guard enabled machines only allow Kerberos Constrained delegation. SSIS double hop authentication will not work with either full delegation or constrained delegation once Credential Guard is enabled. Connecting to an Integration Services catalog server and executing a package from a Credential Guard enabled client will fail with “NT AUTHORITY\ANONYMOUS LOGON”.

    Enabling SSIS to work with constrained delegation is imperative for us since the Credential Guard security feature is enabled in our environment and I am certain that many out there are dealing with the same issue.

    14 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 →
  20. SQL Package on linux looks for dacpac external dacpacs with UPPCASE filenames regardless of the original

    When restoring a dacpac that references another dacpac (linked server) sqlpackage expect that the filename is DATABASE.DACPAC regardless of what the original filename was.

    Replication steps:
    Create 2 projects of type SQL Server Database projects in visual studio, use title case DatabaseOne DatabaseTwo
    Add a database reference from DatabaseOne to DatabaseTwo
    Build Grab the outputted dacpac files
    On a Linux machine / container use sqlpackage to restore the dacpac of DatabaseOne.dacpac

    Expected
    DatabaseOne and DatebaseTwo are published

    Actual
    sqlpackage fails looking for \original path\DATABASETWO.DACPAC

    5 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 →
← Previous 1 3 4 5 266 267
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base