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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Update KB321185 for SQL Server 2019 versions

    2019 is conspicuously missing from this otherwise useful reference article for one-stop version checks for the latest patch levels of SQL Server released. Update or replace this page: https://support.microsoft.com/en-us/help/321185/how-to-determine-the-version-edition-and-update-level-of-sql-server-an
    and the excel file that it links to:
    https://aka.ms/SQLServerbuilds

    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 →
  2. Cannot use external editor with SQLCMD

    SQLCMD returns the error below when the ED command is run to launch an external editor. Repro steps from a Windows command prompt below:

    C:\WINDOWS\system32>sqlcmd -?
    Microsoft (R) SQL Server Command Line Tool
    Version 14.0.3026.27 NT
    Copyright (C) 2017 Microsoft Corporation. All rights reserved.

    C:\WINDOWS\system32>SET SQLCMDEDITOR=notepad.exe

    C:\WINDOWS\system32>sqlcmd
    1> ED
    Sqlcmd: Error: Internal error at ExecProcess (Reason: The filename, directory name, or volume label syntax is incorrect).
    2>

    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 →
  3. SSMS 18.4 nuove tabelle,nuove sp,nuove funzioni...

    Ogni volta che creo una tabella o una stored procedure oppure una funzione, devo chiudere e riaprire ssms per poter farla trovare dalla stessa piattaforma. solo a me capita?
    le query funzionano correttamente lo stesso ma è fastidioso vedere sottolineato di rosso la tabella appena creata e di conseguenza non mi completa/suggerisce in automatico i campi di essa.

    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 →
  4. SSMS 18.4 wrong context menu options

    I've discovered a bug in SSMS 18.4. I suspect it exists in earlier versions.


    1. Right-click the Databases node, choose New Database...

    2. Name it 1.2.3.4, click OK

    3. Right-click on the newly-created database. There is no option to Back up (or restore)

    4. Click on the name (so that you can rename it)

    5. Rename the 1.2.3.4 database 1234 (remove the periods)

    6. Perform step 3 again - this time you'll see the expected Back up... and Restore options.

    It appears that the context menu for SSMS is incorrectly assuming the database type because of the periods in the name.

    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. SSMS 18.4 crashes every time I try to script a SQLDW\ Synapse table.

    SSMS 18.4 crashes on Windows 10, version 1909 every time I try to script a SQLDW table. Faulting module in event log is
    C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll

    I have tried uninstalling\ reinstalling, which did not help. Have had to switch to VS 2019 to do my day to day work :-(

    Same version works fine on Windows 8.1

    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 →
  6. "Import Flat File" causes crash & restart (v18.4)

    SSMS 18.4 crashes and restarts whenever the "Import Flat File" is used. Doesn't even start the wizard...
    (Windows 10 Enterprise version 1803, all updates are current)

    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 →
  7. SSMS not connecting to selected instance when opening a template

    When I open a template from the template browser it automatically connects to the last instance I ran a query against, instead of the selected instance.
    For example I have instance A, B and C connected and I run a query against instance A. If I then select instance C and open the template, the new template query is connected to A again.
    To solve this I first need to create a new empty query against C and then open the template.

    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 →
  8. SSMS not connecting to selected instance when opening a template

    When I open a template from the template browser it automatically connects to the last instance I ran a query against, instead of the selected instance.
    For example I have instance A, B and C connected and I run a query against instance A. If I then select instance C and open the template, the new template query is connected to A again.
    To solve this I first need to create a new empty query against C and then open the template.

    0 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 18 SQL Login Issue

    On SSMS 18 when using the same user with different passwords for each environment ( i.e DEV, UAT, PROD ), the application seem to only store one of the passwords. Only the latest password being used is remembered.

    This is not the behavior of SSMS 17, there it is able to store the password of each environment even if they all use the same username.

    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 →
  10. 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 →
  11. Ein Zertifikat wurde explizit durch den Aussteller gesperrt (0x800B010C)

    MainViewModel.OnBundleAction: Bundle action failed: Ein Zertifikat wurde explizit durch den Aussteller gesperrt (0x800B010C)

    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 →
  12. SSMS2018: Select all does not work after deleting a database

    Steps:
    1. Select databases in the Object Explorer Details
    2. Press delete
    3. In the dialog, select Close Existing Connections
    4. Continue
    5. In a remaining database, on an existing table, right-click and select "Select All Rows"
    6. An Error dialog pops up, referencing one of the deleted databases (see attachment).

    Expected behaviour:
    6. Query window is opened, showing the data of the table.

    Notes:
    - If I remember correctly, the databases I deleted were added in the same session and were still at the bottom of the database list, instead of sorted correctly. This might be relevant, I guess. …

    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 →
  13. SSMS hangs when delete database and click the database picker

    Open SSMS
    New Query for DB1
    Delete DB1
    Click the DB1 name in the databasepicker in the top left menu of SSMS
    SSMS Hangs - at least in this version it doesn't crash.

    Can not change the database conneciton
    Can not change the database using the picker/dropdown.

    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. SQL Server 2019 query fails, it works fine on SQL 2017. This breaks existing code.

    We have the following query:

    Select Top 1 Name
    From

    (Select[Name], Right(Replace(Name, 'CRIS_Master_', '0'), 4) ver
    
    From Sys.databases
    Where State = 0 and Name Like 'CRIS_Master_%'
    ) x

    Where Convert(int, x.ver) <= 504
    Order By x.ver desc

    It fails on SQL server 2019 (version 15.0.2070.41).

    Error: Msg 245, Level 16, State 1, Line 1
    Conversion failed when converting the nvarchar value 'ster' to data type int.

    It does not matter if there are matching rows or not.
    i.e. if I change the like to Name Like 'xCRISMaster%', i.e. prefix search token with x, it still fails.

    This breaks…

    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 →
  15. SQL Server 2019 scalar functions with inline are broken

    This SQL code returns "a" instead of "asdfg":

    CREATE FUNCTION [dbo].[GetPayload2] (@ID int) RETURNS VARCHAR(300) AS
    BEGIN
    IF @ID = 1
    RETURN 'asdfg'
    RETURN ''
    END
    GO
    SELECT dbo.GetPayload2(1)

    Reproduced on both 15.0.2000.5 and 15.0.2070.41. Works fine in SQL Server 2017.
    Workaround is to use WITH INLINE = OFF.

    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 →
  16. Executing a stored procedure over linked server causes access violation error

    On my development machine, I have a database named dm4main. The dm4main may or may not be on the same server and we use a linked server [DM-MainServer] so that our sprocs can work regardless of where it is located.

    If I do this:

    declare @result int
    exec @result = [DM-MainServer].dm4main.dbo.DM_GetProcessIndexId 1, @@SERVERNAME
    select @result

    I receive an error:
    Msg 596, Level 21, State 1, Line 0
    Cannot continue the execution because the session is in the kill state.
    Msg 0, Level 20, State 0, Line 0
    A severe error occurred on the current command. The results, if any, should…

    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 →
  17. SSRS Sorts for Row Groups within a tablix are do not sort correctly

    Tablix that have multiple groups (which may or may not be showing) do not sort correctly based on the level of the group that is being displayed. See attached pdf for more details.

    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. screen paint

    My Screen not updating when switching tabs. I have "N" queries open then wiching between them the old tels will stay on locations that is not covered with other text from another tab.

    So open small file, few lines, then switch to another tab longer text and the screen will not paint the wite space. I have attached a zip file with the screen recording

    My release
    SQL Server Management Studio 15.0.18206.0
    Microsoft Analysis Services Client Tools 15.0.1567.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 Framework 4.0.30319.42000
    Operating System 10.0.18363

    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 →
  19. SQL Server Management Studio 15.0.18206.0 stored procedure scripting issue.

    When scripting a stored procedure commands before create (set ansi nulls, set qoueted identifier) were in separate batches in earlier versions.
    In this version there is no GO after these statements and the result is:

    "CREATE/ALTER PROCEDURE' must be the first statement in a query batch."

    I've looked in scripting options but cannot find an option to fix this and think it should do it out of the box.

    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. Very easy to accidentally rename table in SSMS

    It is far too easy to accidentally rename a table in SSMS. While most other schema changes have lots of warnings and safeguards in place, accidentally renaming a table can happen without the user ever even realizing it has happened. All you have to do is try to start a new query:


    1. Click on a table in the object explorer, to make sure the correct database is focused when you make a new query.

    2. Type ctrl+N to start a new query.

    3. Begin typing SQL.

    That's all it takes: there's a possibility that you've just renamed a table in a live…

    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 266 267
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base