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. BUG CU19 SSAS. Cannot deploy metadata. Altering the referenced object is not permitted

    Error SSAS: Cannot deploy metadata. Reason: Failed to save modifications to the server. Error returned: 'The table referenced by the PerspectiveTable object 'xxxx' in perspective '' cannot be altered. Altering the referenced object is not permitted.

    Good afternoon. I am working with SQL Server 2017 Enterprise Edition and also with SSAS. The Analisys Services server is for hosting tabular models and has a compatibility level of 1200. Until recently, I had been able to make modifications to metrics and columns to the tabular model without any problem and had been able to deploy the DB to the Analisys Services server.…

    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 →
  2. PDW columns in sys.system_columns can break SELECTS using TRY...CATCH or XACT_ABORT

    The following code...

    BEGIN TRY
    
    SELECT collation_name
    FROM sys.system_columns
    where object_id in (-593, -103085222)
    END TRY
    BEGIN CATCH
    END CATCH

    Returns

    Msg 0, Level 11, State 0, Line 2
    A severe error occurred on the current command. The results, if any, should be discarded.

    Also an issue outside the TRY... CATCH context if XACT_ABORT is ON

    Reported by someone here https://stackoverflow.com/q/60285080/73226

    4 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. EXCEPTION_ACCESS_VIOLATION when returning inlined UDF with UserDataAccess from stored procedure

    SQL Server version: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
    Script to reproduce erorr:

    USE tempdb;
    GO

    DROP TABLE IF EXISTS dbo.testtbl;
    GO
    CREATE TABLE dbo.test
    tbl(val int NOT NULL);
    GO

    INSERT INTO dbo.test_tbl(val) VALUES (0);
    GO

    CREATE OR ALTER FUNCTION dbo.test_fn(@val int)

    RETURNS INT
    
    WITH SCHEMABINDING

    AS
    BEGIN

    IF EXISTS(SELECT val FROM dbo.test_tbl) -- UserDataAccess
    
    RETURN @val;
    RETURN 1;

    END
    GO

    CREATE OR ALTER PROCEDURE dbo.test_proc(@val int)
    AS

    RETURN dbo.test_fn(@val);
    

    GO

    EXEC dbo.test_proc @val = 10;
    GO

    10 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 →
  4. Issue of not detecting a table even if exists.

    Issue of not detecting table still exist in latest releases.

    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 →
  5. I can't open Database Diagrams to modify - MS SQL Server Management Studio crashed!

    Today I did update.
    Now I have SQL Server Management Studio 15.0.18330.0
    But I still can't open my diagrams!
    For example, yesterday I made a diagram, saved it, it could open.
    But today can't!
    Please, fix it!

    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 →
  6. SQL Server 2019 RC1 - Secure Enclaves Bug

    When trying to configure Secure Enclaves within 2019 - Allow enclave computations is not an option for us.

    This was apparently resolved in CPT 3.1 however we are still experiencing this issue.

    11 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. SSAS Tabular processing succeeds despite timeout

    The processing of the tabular model succeeds without any error, but in fact there is a timeout after 10 minutes and the model data is incomplete.

    This is very dangerous because it can lead to faulty reporting without notice.

    We have a SQL Server data source with the modern Get Data experience (1400 compatibility level) . There is a table that needs more than 10 minutes to query.

    When we process the model, doesn't matter if per script in SQL Server Agent or directly in SSMS or in VSDT, it ends successfully after 10 minutes, which is the same time…

    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 →
  8. TRY_PARSE and PARSE produce an error converting "NaN" value into Real or Float

    DECLARE @R REAL = TRY_PARSE('NaN' as REAL)
    SELECT @R
    GO

    DECLARE @F FLOAT = TRY_PARSE('NaN' as FLOAT)
    SELECT @F
    GO

    Both statements instead of NULL return an Error: "An error occurred while executing batch. Error message is: Arithmetic Overflow."

    Moreover, you can insert value in a table and any query, which will hit that value will fail with that error.

    DBCC CHECKDB recognizes it as a corruption.

    Seen on 2016 & 2019 on premise.

    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. Full text search host restarts repeatedly under Linux (SQL Server 2019 rc 1)

    Under Linux, after enabling full text search in a table and during the population of the index, one sees frequent messages in the log

    Error '0x80004005' occurred during full-text index population for table or indexed view 'mytable' (table or indexed view ID '629173587', database ID '5'), full-text key value '5567999'. Attempt will be made to reindex it.

    In the errorlog there are many repeated messages like
    The fulltext filter daemon host (FDHost) process has stopped abnormally. This can occur if an incorrectly configured or malfunctioning linguistic component, such as a wordbreaker, stemmer or filter has caused an irrecoverable error during…

    16 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 →
  10. SSIS - ODATA Source - SSDT and Targer SQL Server Language Uncompatibility

    Observed issue when the languages of SSDT and target SQL Server (SSISDB) are different, and there is ODATA source in the package.

    Issue:

    Package execution fails with error: Error: The connection "Connection" cannot be found. Verify that the connection manager has a connection with that name.

    Cause:
    For example, the SSDT language is Chinese, there is a section in package:

              <connections>
    
    <connection
    refId="Package\数据流任务\OData 源.Connections[连接]"
    connectionManagerID="Package.ConnectionManagers[Connection]"
    connectionManagerRefId="Package.ConnectionManagers[Connection]"
    description="与 OData 服务的连接"
    name="连接" />
    </connections>

    name="连接" /> part is causing issue, because when the target SSISDB is English version, when running the package, it will look for the name = Connection.

    This issue…

    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 →
  11. DECRYPTBYPASSPHRASE - returns NULL at times

    The environment is Microsoft SQL Server Web (64-bit) on Windows Server 2016 Standard (10.0).
    I have two stored procedures, one to encrypt and other to decrypt.

    CREATE PROCEDURE USPENCRYPTBY_PASSPHRASE
    (@Passphrase NVARCHAR(50), @Id int, @date NVARCHAR(25))
    AS

    UPDATE T SET ColEncrypted = ENCRYPTBYPASSPHRASE(@Passphrase,@date,1,CONVERT(VARBINARY,T.PK))
    FROM TableA T WHERE T.PK = @Id

    GO

    CREATE PROCEDURE USPDECRYPTBY_PASSPHRASE
    (@Passphrase NVARCHAR(50), @Id int)

    AS

    SELECT convert(date, convert(nvarchar, DecryptByPassPhrase(@passphrase,ColEncrypted,1,CONVERT(varbinary,PK)))) as DATEOFBIRTH

    WHERE PK = @Id

    GO

    Here
    @Passphrase is of 8 characters length,
    PK is primary key of TableA and is an int identity column
    @date is text to be encrypted…

    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 →
  12. SQL server crashed (with dump) on this query (2017, latest CU)

    SQL server crashed on this query
    Query is attached
    Database can be found here (5Mb backup) https://gofile.io/?c=R8oJ1Q

    7 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. ROUND FLOAT BUG

    -- Microsoft SQL Server 2017 (RTM-CU18) (KB4527377) - 14.0.3257.3 (X64)

    SELECT ROUND(CAST(5.175 AS FLOAT),2)
    return 5.17 -- good is 5.18

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

    We’ll send you updates on this idea

    unplanned  ·  3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. Count(*) on VARCHAR Index with blank NVARCHAR or NULL check results in double the rows returned

    I have a table with a VARCHAR column and an index on it. Whenever a SELECT COUNT(*) is done on this table that has a check for COLUMN = N'' OR COLUMN IS NULL it returns double the number of rows. SELECT * with the same where clause will return the correct number of records.

    After reading this article: https://sqlquantumleap.com/2017/07/10/impact-on-indexes-when-mixing-varchar-and-nvarchar-types/ and doing some testing I believe the collation of the column and the implicit conversion isn't the fault (at least not directly). The collation of the column is Latin1GeneralCI_AS.

    The database is on SQL Server 2012, and I've…

    3 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. Query checking doesn't take DROP TABLE into account for temporary tables

    DROP TABLE IF EXISTS #Bug

    SELECT 42 AS Field1
    INTO #Bug

    SELECT Field1
    FROM #Bug

    GO

    DROP TABLE IF EXISTS #Bug

    SELECT 42 AS Field1, 42 AS Field2
    INTO #Bug

    SELECT Field1, Field2
    FROM #Bug

    fails with Invalid column name 'Field2'. The query checker uses the information it has about the schema for #Bug in the second batch, which is invalid because the first thing the second batch does is drop the table.

    3 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. SSMS 18.5 Cannot connect to Azure database - tenant id is an empty guid

    When using SSMS 18.5 build 15.0.18330.0, trying to connect to an Azure-hsoted database using Active Directory Integrated authentication, I receive an error saying that the tenant ID is empty.

    AADSTS900021: Requested tenant identifier '00000000-0000-0000-0000-000000000000' is not valid. Tenant identifiers may not be an empty GUID.
    Trace ID: 0ccbd615-bbe2-4228-828c-0fb3840e3800
    Correlation ID: 40630361-6cff-4f74-bf55-8c105497f692
    Timestamp: 2020-05-05 22:49:08Z (System.Data)

    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 →
  17. ValidateExternalMetadata property is ignored in Microsoft.SqlServer.IntegrationService.ExtensibleFileComponents.Source.ExtensibleFileSource

    This is a component SQL Server Integration Services (SSIS). The component in question is not following the SSIS guidelines and handling ValidateExternalMetadata property correctly.

    Steps to reproduce the issue:


    1. Configure the component using the standard dialog and then close.

    2. Right-click on the component and select Properties. Set ValidateExternalMetadata=False.

    3. Right-click on the component and select 'Show Advanced Editor...'.

    4. Go to 'Input and Output Properties' tab and remove any column from the 'External Columns' element. Close the dialog.

    5. Re-open the dialog again and check the 'External Columns'.

    Observed behavior:
    The removed external column has been added again.

    Expected behavior:
    The modifications to…

    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 →
  18. return performance of sys.dm_sql_Referenced_entities to deprecated function sys.sql_Dependencies

    The deprecated way of getting column references in triggers works fine, however the replacement is about 1000 times slower due to the predicate on referencedEntityName, Referencedminorname being applied at the end of the execution plan.

    SELECT

    depObj.name
    

    FROM

    sys.sql_dependencies dep
    
    INNER JOIN sys.tables tab ON tab.object_id = dep.referenced_major_id
    INNER JOIN sys.schemas sch ON sch.schema_id = tab.schema_id
    INNER JOIN sys.columns col ON col.object_id = dep.referenced_major_id AND col.column_id = dep.referenced_minor_id
    INNER JOIN sys.objects depObj ON depObj.object_id = dep.object_id

    WHERE

    sch.name = 'dbo'
    
    AND tab.name = 'JobVoyage'
    AND col.name = 'JV_VoyageFlight'
    AND depObj.type = 'TR';

    This takes 3 milliseconds…

    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. 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 →
  20. SSAS MD Cell security error v18.5

    Cell Data security model does not work with SSMS v18.5.
    I get error on the created role:
    "Tabular metadata and DAX queries are not supported when there is cell security defined for this session. Please contact your administrator for more information. (Microsoft SQL Server 2017 Analysis Services)".

    But it still works with previous versions like v17.9.1 .

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

SQL Server

Categories

Feedback and Knowledge Base