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 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() …

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

    We’ll send you updates on this idea

    7 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Matteo Taveggia responded

    Thanks for reporting this issue. I may have to reach out to the DacFx Team.

    Would you be able to share the bacpac with us, perhaps on OneDrive or equivalent? I do understand that it may contain sensitive information and may not be an option for you.

    Thanks,
    -Matteo

  2. Ambiguity on OLE DB Driver 18 for SQL Server download page

    The "Microsoft® OLE DB Driver 18 for SQL Server®" download page allows you to download two identically named files with no disambiguation. Obviously, one is for 32bit and one is for 64bit, but the page provides no way to tell which one.
    Problem is on download site here: https://www.microsoft.com/en-us/download/details.aspx?id=56730
    Can we get some identifying information associated here when choosing which of the files to download? Confusing to have no way to tell which one is 64bit.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  3. ssms query store issues/suggestions

    SSMS 18.4

    Bugs


    1. When using the detailed grid (with additional details) returning 'Top nn', it is not returning the same metrics that is shown in the simple grid and chart. It does work correctly when returning 'All'. Test case: the same set of query id's should be listed in all cases.

    2. Sorting by a column in the simple grid, it changes the metric which does not match the configured metric. This works correctly in the detailed grid. Test case: the same set of query id's should be listed in all cases.

    3. Sorting by a column should not query the Query…
    1 vote
    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 →

    Ack on the reported issues under the Bugs section. Thank you for reporting.

    For future reference, it would be more actionable if what’s under Annoyances and Suggestions could be opened as separate feedback items (maybe even if collating those that may be related), but let them accrue votes from other community members on those separate scoped items.

  4. 1 vote
    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. Trace Flag/sp_configure Option to Allow Developer or Evaluation Editions to "Act" like Standard Edition

    One of the challenges for many customers who need to use Standard Edition is that both Developer and Evaluation Editions of SQL Server are the same functionally as Enterprise Edition. This means that in non-production scenarios/environments, without buying a full license of Standard Edition (or having MSDN), you are potentially using (or able to use) features not available in Standard. Dev and Eval should have a way to allow those who will ultimately be using Standard to constrain what features are used as well as any performance limitations in Standard so their eval/dev/testing efforts are accurate.

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

    We’ll send you updates on this idea

    17 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Recursive CTE breaks SQL Server service

    Query below crashes SQL Server service. Tested on SQL Server 2017 Developer Edition CU16.

    ;with cterecursive as
    (
    select
    convert(char(8000), '') column1
    ,convert(char(79), '') column2
    union all
    select
    convert(char(8000), '') column1
    ,convert(char(79), '') column2
    from cte
    recursive
    )

    select *
    from cte_recursive

    3 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. Misspelling a XEvent actions' description, server_principal_sid, at SQL Server 2019 RC1

    I found a misspelled word in the serverprincipalsid description.

    Prinicipal -> Principal

    2 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 →
  8. SSMS 18.2 cannot create replication subscriptions

    I am attempting to configure a new subscription for an existing publication, which already has other subscribers. (This is a merge publication on a SQL Server 2008 R2 system.)
    I right-click on the publication in the treeview and select "New subscriptions..."

    The "New Subscription Wizard" opens, and I click "Next" at the introduction page.
    The next page is where I select my publication. My publications are displayed in this window, so all is good so far. I select a publication in the list and click Next.
    At this point I get an error and the wizard will not continue:
    Invalid…

    1 vote
    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. URGENT: "Feature Restrictions" actually increases chances of SQL Injection and must be removed immediately (before RTM)

    The new "Feature Restrictions" feature that was introduced in CTP 3.2 of SQL Server 2019 is highly problematic. It is an ill-conceived feature that does not prevent SQL Injection in any way. It doesn't mask user error messages (only system errors), and it prevents WAITFOR but not a WHILE loop that accomplishes the same delay. So this feature is absolutely useless.

    Actually, it's worse than that because people will assume that this feature actually does prevent these things, which will give them a false sense of security.

    This feature is not fixable and needs to be removed entirely. This needs…

    4 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 →
  10. Microsoft.SqlServer.SqlManagementObjects library not working as expected in .net core

    var sql = new Microsoft.SqlServer.Management.Smo.Server();
    sql.ConnectionContext.LoginSecure = true;
    sql.ConnectionContext.ConnectAsUser = true;
    sql.ConnectionContext.ConnectAsUserName = "DomainUser";
    sql.ConnectionContext.ConnectAsUserPassword = "Password";
    sql.ConnectionContext.ServerInstance = @"Server\Instance";
    sql.ConnectionContext.Connect();

    above code should connect sql server with different user, but it always taking credential of currently logged in user. Its working fine with .Net Framework, only having issues with .Net Core.

    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 →
  11. Allow Updating Statistics on the Secondary Replicas of the Availability Groups

    Allow remote (on the secondary replicas) statistics update for the Availability Groups. Given that a lot of time the secondary replicas have extra resources
    Potentially this could lead into spreading & parallelising the statistics recalculation processes while doing maintenance or potentially even ad-hoc.
    The original idea behind this is described in the following blogpost – http://www.nikoport.com/2019/06/20/updating-statistics-on-secondary-replicas-of-the-availability-groups/

    61 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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Generate scripts feature returns an error on 18.1 (15.0.18131.1)

    Whenever I try to generate db scripts for any of dbs on the server I got an error (attached on this post).

    Running SSMS 18.1 over Microsoft SQL Server 2014 (SP2-GDR) (KB4019093) - 12.0.5207.0 (X64)

    1 vote
    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 →
    under review  ·  Matteo Taveggia responded

    Thanks for the suggestion. We’ll take a look at it and prioritize accordingly.

    Thanks,
    -Matteo

  13. Bug in SSMS on Statistics Properties screen

    There is a "Update statistics for these columns" checkbox In SQL Management Studio in Statistic Properties dialog.

    However when I click on this checkbox and press OK it has no effect what so ever. Statistics are not updated and when I try to script the action I get "There is no action to be scripted".

    1 vote
    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 →
  14. Import Flat File wizard, add check box for file does not include header row.

    When importing a csv without a header row, it's removing the first row of data. It would be nice if the wizard had a option to say that this file does not contain a header row. The modify columns already allows for adjusting the column names but it still removed the first row of the .csv.

    2 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 →
  15. ssms 18 hangs

    SSMS version 18.0 hangs when trying to connect to the Master database in Azure SQL DB, when the user does not have access to the Master database.

    4 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 →
  16. BUG: Statistics cannot be set to incremental when the Partition Function contains a "." (dot)

    Hi,

    We are moving SQL 2012 databases to SQL 2016, and some databases contain partitioned tables.

    Being SQL2016, I want to make use of incremental statistics, but when I enable incremental statistics on the existing statistics/indexes, I always received the following error: "Incorrect syntax near '.'."

    This error shows up for each partition that contains data.

    After a lot of testing, I found out that it is caused by the name of the Partition Function.
    This contains a "." ("PF_dbo.ID") .

    Has anybody run into this problem and found a way to solve it without needing to rebuild each partitioned…

    1 vote
    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 →
  17. Issue Flat File Export

    When I export data from SQL Server into flat file, the wizarad ask for destination file name, locale, code page,...
    When I select English for locale, I can show the preview, but when press finish the export, I get this error message for validation

    Validating (Error)
    Messages
    Error 0xc00470b6: Data Flow Task 1: The LocaleID 9 is not installed on this system.
    (SQL Server Import and Export Wizard)

    Error 0xc004706b: Data Flow Task 1: "Destination - PRUEFAUF1txt" failed validation and returned validation status "VSISBROKEN".
    (SQL Server Import and Export Wizard)

    Error 0xc004700c: Data Flow Task 1: One or…

    1 vote
    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 →
  18. SSMS 18.0 GA Create script for functions missing GO statements after SET statements

    SSMS 18.0 GA Create script for functions missing GO statements after SET statements.

    1 vote
    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 →
  19. Sql Server Management Studio / Always Encrypted Parametrization

    The order of the parameters in SSMS (v.17.9.1) seems to be critical when using encrypted and not encrypted columns in one statement.

    Declaring the not encrypted variable before encrypted vars works, the other way it doesn't work (ERROR: ncryption scheme mismatch for columns/variables .. see more details and example in the file attached.)

    best regards,
    Roman

    1 vote
    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 →
  20. SSMS 18.0 RC1 is prompting for authentication upon scripting out an object from Object Explorer.

    I know this is happening on version 15.0.18098.0.

    The Scenario: You have a server in Object Explorer that you authenticated to. You navigate to a table in one of the databases. You right-click on the table. You choose "Script Table as" -> "CREATE To" -> "New Query Editor Window". You are then prompted with the "Connect to Database Engine" window for server selection and authentication.

    This is not something that happens in SSMS 17. I installed this yesterday and when I did so I choose the option to port over all my settings from 17. Everything else has been working…

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

SQL Server

Categories

Feedback and Knowledge Base