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. Arithmetic overflow error converting expression to data type int

    Getting Arithmetic overflow error when i run sp_monitor system stored procedure.

    SQL Server version: SQL 2016 CU8

    Seems the variable must be declared as bigint instead of int to accommodate "sp_monitor" result in the event the server restart not happened frequently

    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. Tried to run SSMS setup .exe but nothing pops out

    Tried to run SSMS setup .exe but nothing pops out

    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 →
  3. Faulting application name: Ssms.exe, version: 2019.150.18142.0, time stamp: 0x5d3573be Faulting module name: KERNELBASE.dll, version: 10.0.1

    Running a query runs for several minutes, then SSMS crashes:

    -----first error ---------------
    Application: Ssms.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.ComponentModel.Win32Exception
    at System.Windows.Forms.NativeWindow.CreateHandle(System.Windows.Forms.CreateParams)
    at System.Windows.Forms.Control.CreateHandle()
    at System.Windows.Forms.TextBoxBase.CreateHandle()
    at System.Windows.Forms.Control.CreateControl(Boolean)
    at System.Windows.Forms.Control.CreateControl(Boolean)
    at System.Windows.Forms.Control.CreateControl()
    at System.Windows.Forms.Control.WmShowWindow(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.UpDownBase.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr)

    ------------------------------------- second error ----------------------------

    Faulting application name: Ssms.exe, version: 2019.150.18142.0, time stamp: 0x5d3573be
    Faulting module name: KERNELBASE.dll, version: 10.0.17763.652, time stamp: 0x57e2061a
    Exception code: 0xe0434352
    Fault offset: 0x0011fd82
    Faulting process id: 0x2064
    Faulting application…

    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. If you load data into the "Edit top ***" rows then click away while the data is being loaded, invalid data is displayed

    I had a small table of data open using the "Edit top ***" option. Then, I opened the same table using the "select top xxxx" option. Through some combination of clicking back and forth between those two tabs, the data in the first tab became corrupted and started to show, what I can only describe as "chinese" characters. It seemed to happen more "reliably" if I clicked away while data was being loaded into the edit view. Screenshot attached.

    There is so much weird about this though. The columns types ID=int, Name=varchar, Value=varchar, InVault=bit. As you can see the row…

    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. Intellisense sleeps

    Intellisense is enabled but sometimes sleeps, won't work, no suggestions.
    Disabling and enabling intellisense don't help.
    I've to close SSMS and restart it, hoping it works.

    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. 52

    jhjhgj

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

    I found a misspelled word in the server_principal_sid 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 Object Reference message when try connect to Single User Mode DB

    WHen I have a local database in SINGLE USER MODE, and I try and use Trasnact SQL to USE that database, it sits on "Executing" forever. When I click cancel query, I get msgBox "Object Reference not set to an instance of an object"

    Microsoft SQL Server 2017 (RTM-GDR) (KB4505224) - 14.0.2027.2 (X64) Jun 15 2019 00:26:19 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 17763: ) (Hypervisor)

    Microsoft SQL Server Management Studio 14.0.17285.0
    Microsoft Analysis Services Client Tools 14.0.1016.283
    Microsoft Data Access Components (MDAC) 10.0.17763.1
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer…

    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. SQL Agent doesn't fail when statement is terminated

    I have a strange situation where a step in a SQL Agent job fails. The history reveals a message: The statement has been terminated. [SQLSTATE 01000] (Message 3621). But then it also says the step succeeded. This appears to be a bug. Is this not an error? Is this not a failed job???

    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. SSMS 15.0.18142.0 SQL Graph BacPac Export Error

    Creating a bacpac from a db with an sql graph edge table and a constraint in an edge + additional colum fails with the following error message:
    One or more unsupported elements were found in the schema used as part of a data package.
    Error SQL71501: Error validating element <unnamed>: Unique Constraint: [dbo].[UC_Edges_Order] has an unresolved reference to Column [dbo].[MyEdges].[from_obj_id_C2A9F474D61948B2AC5433359A850182].
    Error SQL71501: Error validating element <unnamed>: Unique Constraint: [dbo].[UC_Edges_Order] has an unresolved reference to Column [dbo].[MyEdges].[from_id_EF40F0725C814171A60218DB242C635D].
    (Microsoft.SqlServer.Dac)

    Steps to reproduce:
    1. SQL Server 14.0.3192.2
    2. SMSS 15.0.18142.0
    3. Create database
    4. Create edge table:
    CREATE TABLE MyEdges (
    [Order] INT…

    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. SQL Server 2016 SP2 CU8 EXCEPTION_ACCESS_VIOLATION.

    When accessing by Linux Microsoft ODBC Driver the view, which uses PIVOT function the SQL Server kills the connection with
    SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    The problem is new for CU8 and does not exists for CU7.

    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 →
  12. ALL() Filter in Tabular without arguments not working in frontend

    The Calculated column or measure can be created in Tabular without an ALL Argument and is working, but is not usable in a frontend like Excel or Power BI. The goal is to get rid of the whole Filter context on all tables.
    Detail Example eplanation with code:

    Used:
    - SQL Server 2017 (14.0.2027.2)

    - VS Enterprise 2017
    - Used Front-Ends:
    ○ PowerBI with Live-Connection (Version in Attachements)
    ○ Excel 365

    - Data model is based on "AdventureWorksDW2012"

    - Based on the AdventureWorksDW2012 database I built a tabluar model which is unchanged.
    - Only new measures based on data from…

    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. same query return nothing sometimes with the same data

    I have this query:
    SELECT *
    FROM Table T
    WHERE ISNULL(T.Date, GETDATE()) >= GETDATE()

    Where T.Date is Type (datetime2(0), nullable)

    The thing is... when I run de query sometimes I have nothing and sometimes I have the expected response which is a static number of rows, then if you run it, again and again, you obtain nothing or the same rows number, I think the problem is in the implicit type conversion between T.Date and GETDATE() to make the comparison between both

    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. SSMS 18.2 Edit Job Step hangs

    In SSMS 18.2 when we edit a job step under Job properties it takes minutes to open the edit box

    6 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. 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 →
  16. Simple query crashes SQL Server service

    Hello,

    I managed to crash SQL Server service by running simple query. I'm attaching log files. I deleted query from it, so it is not available publicly. In case exact query is needed, I can send it via e-mail.

    OS and SQL Server details are in log files.

    BR

    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 →
  17. Exception when trying to create a new DAX query in SSMS 18.2

    When I try and run a DAX query from SSMS 18.2 I get the following error:

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Object reference not set to an instance of an object. ( at Microsoft.VisualStudio.Text.Editor.Implementation.WpfTextView.UnsubscribeFromEvents()
    at Microsoft.VisualStudio.Text.Editor.Implementation.WpfTextView.Close()
    at Microsoft.VisualStudio.Text.Editor.Implementation.WpfTextViewHost.Close()
    at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.CloseExistingWpfTextView()
    at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.CloseBufferRelatedResources()
    at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.CloseView()
    at Microsoft.VisualStudio.Editor.Implementation.CompoundTextViewWindow.Close()
    at Microsoft.SqlServer.Management.UI.VSIntegration.ShellCodeWindowControl.UnsinkEventsAndFreeInterfaces()
    at Microsoft.SqlServer.Management.UI.VSIntegration.ShellTextEditorControl.Dispose(Boolean disposing)
    at System.ComponentModel.Component.Dispose()
    at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptEditorControl.Dispose(Boolean bDisposing)
    at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.Dispose(Boolean bDisposing)
    at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.MdxScriptEditorControl.Dispose(Boolean bDisposing)
    at Microsoft.SqlServer.Management.UI.VSIntegration.ShellWindowPaneUserControl.OnWindowPaneClose()
    at Microsoft.SqlServer.Management.UI.VSIntegration.ShellWindowPaneUserControl.ClosePane()
    at Microsoft.VisualStudio.Platform.WindowManagement.WindowPaneDocumentObject.<>c__DisplayClass19_0.<DisposeManagedResources>b__0()
    at Microsoft.VisualStudio.ErrorHandler.CallWithCOMConvention(Action method, Boolean reportError))

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    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 →
  18. SSMS 18.2 View Creation Issue

    There is an issue when creating a new view in SSMS 18.2. Follow these instructions to replicate.

    1. Expand a database in SSMS 18.2 by clicking the + sign next to the database name
    2. Right click on "Views"
    3. Select "New View..."
    4. The add table dialog will appear.
    5. Right click on the View creation screen and select "Add Table"
    6. Once the Add table dialog appears, select a table and click Add.
    7. Click "Close" on the dialog.
    8. Close the view editor.

    Now if you look at the original "Add Table" dialog that is on the…

    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 →
  19. string_agg - error - "Incorrect syntax near 'within'" - Specific SQL Server Version

    On specific version of SQL Server including the "within group" clause as part of the STRING_AGG function errors out.

    The error states :-

    Msg 102, Level 15, State 1, Line 83
    Incorrect syntax near 'within'.

    Failing, SQL Server Version Number is :-

    Microsoft SQL Server 2017 (RTM-CU9-GDR) (KB4293805) - 14.0.3035.2 (X64) Jul 6 2018 18:24:36 Copyright (C) 2017 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

    Verifiable fixed in :-

    Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64) Nov 30 2018 12:57:58 Copyright (C) 2017 Microsoft Corporation Enterprise Edition: Core-based…

    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. string_agg - error - "Incorrect syntax near 'within'" - Specific SQL Server Version

    On specific version of SQL Server including the "within group" clause as part of the STRING_AGG function errors out.

    The error states :-

    Msg 102, Level 15, State 1, Line 83
    Incorrect syntax near 'within'.

    Failing, SQL Server Version Number is :-

    Microsoft SQL Server 2017 (RTM-CU9-GDR) (KB4293805) - 14.0.3035.2 (X64) Jul 6 2018 18:24:36 Copyright (C) 2017 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

    Verifiable fixed in :-

    Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64) Nov 30 2018 12:57:58 Copyright (C) 2017 Microsoft Corporation Enterprise Edition: Core-based…

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

SQL Server

Categories

Feedback and Knowledge Base