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. My replication monitor keeps crapping out on me. Like now, it is seen below in my taskbar, but I cannot open it. This is a huge issue that

    My replication monitor will not open. This happens all the time since 18... and a repair is all that fixes it. Rather annoying.

    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. parsename fails to return data when there are spaces in the string and at least on part is quoted.

    parsename fails to return data when there are spaces in the string and at least on part is quoted. A repro:

    DECLARE @str nvarchar(1000)
    SELECT @str = 'tempdb . "sys" . objects'
    EXEC ('SELECT * FROM ' + @str)
    SELECT parsename(@str, 3), parsename(@str, 2), parsename(@str, 1)

    Books online says:

    PARSENAME returns NULL if one of the following conditions is true:

    •Either object_name or object_piece is NULL.

    •A syntax error occurs.

    The requested object part has a length of 0 and is not a valid Microsoft SQL Server identifier. A zero-length object name renders the complete qualified name as not valid.

    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 →
  3. 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 →
  4. SSMS ver 18.2 - Strange behavior when trying to copy from search and replace box

    Steps to reproduce:

    In SSMS ver. 18.2 create some query, for example select TOP 1000 rows from a table
    Double click on a table field and press CTRL + H (attempting a copy/replace)
    Highlight the top field in the Find and Replace box using the mouse (in this case, [Vendor_ID])
    Press CTRL + C to copy it.
    You now get this error:

    SSMS_error - see attached

    I saw it happening also in SSMS ver. 18. 1 but not in SSMS ver, 17

    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 →
  5. SSMS ver 18.2 - Strange behavior when trying to copy from search and replace box

    Steps to reproduce:

    In SSMS ver. 18.2 create some query, for example select TOP 1000 rows from a table
    Double click on a table field and press CTRL + H (attempting a copy/replace)
    Highlight the top field in the Find and Replace box using the mouse (in this case, [Vendor_ID])
    Press CTRL + C to copy it.
    You now get this error:

    SSMS_error - see attached

    I saw it happening also in SSMS ver. 18. 1 but not in SSMS ver, 17

    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 →
  6. Stop making your products worse- import functionality is terrible!

    Stop making your products worse- import functionality is terrible! For some stupid reason only flat fiels can now be imported and SQL messes this up, e.g. no matter what data type I select SL insists on importing a number field as a time field

    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. Unhandled exception in table export

    In SSMS/<Database>/Tasks/Generate Scripts: When trying to export the data (without the schema) of certain tables (just 5 of more than 1000 selected), the following unhandled exception is thrown:

    ===================================

    Exception has been thrown by the target of an invocation. (mscorlib)

    ------------------------------
    Program Location:

    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
    at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
    at System.Delegate.DynamicInvokeImpl(Object[] args)
    at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
    at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
    at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
    at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
    at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
    at System.Windows.Forms.Control.WndProc(Message&…

    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. Secret controller-token-secret does not exist

    I have followed https://docs.microsoft.com/en-us/sql/big-data-cluster/deployment-guidance?view=sqlallproducts-allversions for minikube and Kubeadm, and in both cases get an error when trying to log in with azdata:

    2019-08-16 04:25:02.3658 | ERROR | [Request 0HLP20320PR30:00000001] An unhandled exception occurred Microsoft.SqlServer.Controller.Common.ControllerException: Fail to retrieve JWT key: Secret controller-token-secret does not exist.. ---> k8s.KubernetesException: Secret controller-token-secret does not exist.
    at Microsoft.SqlServer.Kubernetes.Client.KubernetesClient.GetSecret(String secretName, String namespace, IDictionary`2 labels, Boolean ignoreNotFound)
    at Microsoft.SqlServer.Controller.Service.Token.JwtTokenFactory.GetSigningSecurityKey()

    Do I miss anything and how can I fix this? Who is supposed to create a secret? It is indeed missing in the namespace. Thanks

    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. Microsoft.ReportingServices.ReportViewerControl.WebForms 150.1358.0: Error Could not load file or assembly 'Microsoft.ReportViewer.Design'

    SUMMARY

    It seems version 150.1358.0 only fixed two of the three DLLs with version = 15.3.0.0.

    Version 150.1357.0 DLLs with version = 15.3.0.0:

    1) Microsoft.ReportViewer.DataVisualization
    2) Microsoft.ReportViewer.Design
    3) Microsoft.ReportViewer.ProcessingObjectModel

    Version 150.1358.0 DLLs with version = 15.3.0.0:

    1) Microsoft.ReportViewer.Design

    WORKAROUND

    Two options:

    1) Edit the Web.config to replace the Microsoft.ReportViewer.Design Version:

    <!-- Workaround for v150.1358.0, which shipped 15.3.0.0, not 15.0.0.0 -->
    <add assembly="Microsoft.ReportViewer.Design, Version=15.3.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>

    2) Downgrade to 150.900.148. This restores all files to Version = 15.0.0.0.

    ENVIRONMENT DETAILS

    Microsoft Visual Studio Professional 2017: v15.9.15 (latest)
    .NET Framework: 4.8
    Microsoft.ReportingServices.ReportViewerControl.WebForms: 150.1358.0 (latest)
    Microsoft.SqlServer.Types: 14.0.1016.290 (latest)
    Microsoft RDLC Report Designer: 15.3.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 →
  10. [SMO] ScriptingOptions.ScriptForCreateDrop = true is being ignored

    ENVIRONMENT:
    Microsoft.SqlServer.SqlManagementObjects (150.18147.0)

    ISSUE:
    When using SMO's Scripter class to script database objects to a SQL file, ScriptingOptions.ScriptForCreateDrop = true is being ignored.

    ScriptMaker.ScriptUrns(List<Urn> orderedUrns) does check the ScriptingPreferences.Behavior property for the ScriptBehavior.DropAndCreate value, but ScriptingOptions.ScriptForCreateDrop never gets translated to a ScriptBehavior value in the first place. Instead, it resides in ScriptingPreferences.ScriptForCreateDrop, where it never gets used.

    EXPECTED BEHAVIOR:
    Setting ScriptingOptions.ScriptForCreateDrop = true should set ScriptingPreferences.Behavior = ScriptBehavior.DropAndCreate, so that drop and create statements are generated.

    WORKAROUND:
    Setting ScriptingOptions.scriptingPreferences.Behavior = ScriptBehavior.DropAndCreate via Reflection.

    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. Restore database freezes when I try to select a file to restore from

    I backed up a database on a server and copied the bak file to my local machine. Tried to restore it using Tasks > Restore but when I click the "..." button to choose a file to restore from, the restore dialog freezes. I waited a few minutes but it still never responded. Therefore I'm unable to restore this database; if I try to do it using the command interface, I get all sorts of errors about missing files!

    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. Creating View in SSMS Visual Designer with Geometry::UnionAggregate causes application to crash

    When trying to create a view in the visual designer with Geometry::UnionAggregate, it causes SSMS to completely crash. It can be created using syntax just fine.

    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. Unable to restore backups through Azure Data Studio or SSMS after 2017 CU14

    There was a bug introduced into Sql Server on Linux 2017 CU14. It is not possible to list the directories in Azure Data Studio or SSMS.

    A couple of links to reports of the bug:
    https://github.com/microsoft/mssql-docker/issues/475

    https://github.com/microsoft/mssql-docker/issues/460

    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. 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. clicking the help link on an error dialog asks me if its OK to send info across the internet and then takes me to the ms home page

    Clicking the help link on an error dialog asks me if its OK to send info across the internet and then takes me to the ms home page

    Its not like its going to send the data unencrypted, and who cares about the program name, version, and event code anyway?

    This was the url it generated when clicking Help and saying OK.
    https://www.microsoft.com/en-us/?ProdName=Microsoft+SQL+Server&ProdVer=14.00.1000&EvtSrc=MSSQLServer&EvtID=15404

    This does not at all help me get diagram support to work in SSMS 18.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 →
  16. SqlPackage.exe - CREATE USER [<name>] FOR EXTERNAL PROVIDER;

    CREATE USER [<name>] FROM EXTERNAL PROVIDER; is the correct syntax for creating database users from Azure AD.

    SqlPackage.exe generates CREATE USER [<name>] FOR EXTERNAL PROVIDER;. Executing this creates an invalid database user.

    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 →
  17. SSMS: Export of SSIS Project into ispac from Server doesn't wor

    when using the export function for an ssis project in SSMS 18.2 an error message comes up. The export fails and results in an an empty ispac file. Exporting the same project from the same server works with SSMS 17.9.1 but not with 18.2

    Info of SSMS which fails:
    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 4.0 6.0
    Microsoft Internet Explorer 9.11.14393.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.14393

    ===================================

    Version of SSMS that succeeds:
    Microsoft SQL Server Management Studio 14.0.17289.0
    Microsoft Analysis Services Client Tools 14.0.1016.283 …

    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. Bug in SSMS Import Flat File

    Got the following error when trying flat file import of the attached file: "Column 'B' does not allow DBNull.Value." Set data types to float for columns A/B/C/D, nvarchar(50) for E. Allow Nulls left unchecked for all columns.

    The same import works with the old "Import Data" wizard.

    -----------------------

    Environment:
    SQL Server Management Studio 15.0.18142.0
    Microsoft Analysis Services Client Tools 15.0.1389.0
    Microsoft Data Access Components (MDAC) 10.0.17763.1
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer 9.11.17763.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.17763

    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 →
  19. SQL Server 2019 CTP 3.2 doesn't allow you to add Python after the initial install.

    Re-run the setup from the media folder, choose to add a feature to an existing instance, pick your instance, and then it acts like you're adding a new instance about 80% of the time, or otherwise looks like it's proceeding and then the installer just disappears.

    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. MakePreviousWritesDurable error

    Restoring AdventureWorks in Linux docker issue, possibly due to named volumes?

    See https://github.com/MicrosoftDocs/sql-docs/issues/2606

    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?

Feedback and Knowledge Base