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 Microsoft Q&A or Stack Overflow

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Report Builder Windows Authentication does not work over the proxy server that requires authentication

    ReportBuilder fails to connect to the RS server through the proxy server that requires authentication.

    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 →
  2. sp_executesql in combination with alter database set recovery fails

    sp_executesql and/or alter database fails when trying to change recovery model of a database. The command should be translated to "ALTER DATABASE AdventureWorks SET RECOVERY SIMPLE", which runs perfectly.

    It would be nice to have this fixed, as the code i to be used within a loop.

    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 →
  3. locktimeout causes abort transaction when using output

    create table a (i int)
    insert into a values (1)

    thread 1 run
    begin transaction xxx
    go
    declare @id bigint
    select top 1 @id = i from a WITH (READPAST)
    update a with (nowait) set i = i where i = @id

    see below for reproduce steps for what to run in thread 2

    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 →

    Upvotes: 1

    <=-=Jan 17 2008 12:32PM=-=>

    Hello

    Thank you for reporting this issue. We are investigating why the transaction is aborted when using the OUTPUT clause in the UPDATE statement for this particular scenario. We will get back to you when we have more information.

    SQL Server team

  4. SQL Server Management Studio bug in Import Data Wizard with DB2 driver

    The SQL Server version I am using is:

    Microsoft SQL Server 2005 - 9.00.2047.00 (X64)

    Apr 14 2006 01:11:53 
    
    Copyright (c) 1988-2005 Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

    I was trying to use the Database "import data" task in Studio Manager. After specifying the IBM OLE DB Provider for DB2 and entering the appropriate property information, I received the following message:

    SQL8002N Connect processing failed; a valid product license was not found. SQLSTATE=43968

    The version of DB2 Connect I am using is DB2 Connect Personal Edition 64 Bit V8.2 fix pack 9.…

    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 →

    Upvotes: 0

    <=-=Dec 13 2007 9:58AM=-=>

    Thank you for your submission. We have reviewed the problem but we were not able to include a correction in the Katmai release. I have place this issue in the next phase so that it may be considerable for the next release.

  5. cube content security

    I set up security for the cube writing the proper text in the "Allow reading of cube content" textspace, in BIDS.
    I'd like that, for all the measures different from �Mea1�, the �01� �02� members and even the aggregated cells of the dim-hier [Dim Mesi].[Dim Mesi] would be accessible to the users, in the same way as it happens if you enable security directly on a dimension from the Dimension Data Tab.

    This works for the Measure "Costi2" which has not any calculations applied through the cube script. But this doesn't work for the Measure "costi1" to whom I applied…

    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. SQL Agent : Log File Viewer : server vs. client times

    You fixed the duration column I complained about in Connect item #124841 (thank you!).

    Now I am seeing another artifact of this issue, where the GUI can't decide whether to show server time or client time.

    This is still in the log file viewer, in the Date column. In the following screen shot, the server is set to UTC, and my client machine is eastern time. The job started a few minutes ago, but step 1 completed 4 hours before the job started!

    http://www.aaronbertrand.com/voodoo/SSMSagentGMT.gif

    Not only is this disconcerting because of the difference in hours, it also makes…

    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 →

    Upvotes: 4

    <=-=Jun 6 2007 11:29AM=-=>

    Aaron,

    Thanks for the report – we’ll be looking at this for Katmai.

    -Richard Waymire

    <=-=Mar 11 2008 2:16PM=-=>

    Aaron,

    We ran out of time to fix this in SQL Server 2008, I’m moving the bug to next major release.

    -Richard Waymire

    <=-=Jun 26 2009 2:07PM=-=>

    Hi, we plan to address this issue in SQL11.

    Thanks,

    Gil

    <=-=Jul 14 2009 10:29PM=-=>

    Wouldn’t it be possible to use something like “Closed (Postponed)” instead of “Closed (Won’t Fix)”? When you say that something won’t be fixed, it looks like it will be ignored forever.

    Thanks.

    <=-=Jul 16 2009 8:38AM=-=>

    Stephen -

    In response to: ’Wouldn’t it be possible to use something like “Closed (Postponed)” instead of “Closed (Won’t Fix)”? When you say that something won’t be fixed, it looks like it will be ignored forever.’

    This bug isn’t even closed – we do hope to fix…

  7. SQLBPA 2.0 - Need to be able to specify port for instance

    The Feb CTP of SQLBPA 2.0 allows me to specify a computer name to run the BPA against. I am running SQLBPA from my client desktop (W2K SP4) to servers (W2K3 and W2K3x64) on the network. It is able to connect and show all the SQL 2005 components and instances. However, when I select an instance it is unable to connect to perform the analysis. When running SSMS from the same desktop, I have to specify the port in order to connect to the instance - servername\instance,port. So, I suspect that is the same problem here. We need to be…

    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 →

    Upvotes: 1

    <=-=Mar 30 2007 2:07PM=-=>

    I tried a little more patience and the scan for Analysis Services does finally return – but took nearly 40 minutes to run the “Collecting command data for host [servername]” step. Likewise, the scan for Integration Service took a similar lengthy time. Is this the expected performance? We have hundreds of servers\instances on which we are going to want to execute this tool…unless performance makes it impractical.
    Thanks,
    Nancy Hidy Wilson

    <=-=Mar 30 2007 2:08PM=-=>

    Oops – that should have read “Collecting common data for host [servername]” in the previous post.

    NHW

    <=-=Jul 9 2007 9:53AM=-=>

    I haven’t tried analysis services but when I try to connect to a non-standard port for the database engine it comes back right away with the message about services running / correct credentials etc. Which is not right since the services are running and I am using the…

  8. SSMS unable to list databases if logged in as limited user

    If user has limited right, SSMS unable to list databases, even if user have access to some of them

    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. SQL 2008 does not support Windows 2008 and W2K8 R2 Multi-site cluster

    SQL 2008 does not support Windows 2008 and Windows 2008 R2 Multi-site (multi-subnet) cluster. I tried to install SQL 2008 onto both Win2k8 and Win 2K8 R2 multi-site cluster but it fails to install properly on either platform. I had opened up a premier support call for this and was told the SQL 2008 does not support the new W2K8 Multi-Site cluster

    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 →

    Upvotes: 4

    <=-=Jun 1 2009 1:17AM=-=>

    Thanks for your feedback. We’re looking at the support for SQL cluster across different subnets for SQL11 release.

    Jason

    <=-=Jun 3 2010 8:30PM=-=>

    Closing the loop.

    SQL Server 2008 and SQL Server 2008 R2 don’t support deploying SQL Server failover cluster over multiple subnets. We are investigating if this can be enabled in next SQL release.

  10. Detaching job from schedule delete schedule

    In SSMS 2008, I get the following error and schedule is deleted when I unselected job from schedule ("Jobs referencing a Schedule" window) :
    Cannot access properties or methods for the Microsoft.SqlServer.Management.Smo.Agent.JobSchedule 'CollectorScheduleEvery6h', because it has been dropped. (Microsoft.SqlServer.Smo)

    When I remove schedule from job ("Job Properties" window), schedule is deleted.
    In SSMS 2005 schedule isn't deleted.

    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 →
  11. XML DML delete causes problems with xsi nil

    After running delete XML DML query xsi:nil="true" is appended to some nodes (not related to query). This does not happen when running 'insert' or 'replace'.

    This is quite serious issue for me - I am using xsi:nil to distinguish null from empty string.

    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 →

    Upvotes: 1

    <=-=Jan 2 2009 3:35PM=-=>

    Hi Marcin

    Thanks for reporting this problem. This is a known issue with the way that we internally keep track of xsi:nil values… the fix is not easy and so far not many people have stumbled across it in real-world scenarios. However, with your report we are taking another look at fixing it… if you need a fix quickly, I recommend that you file a support case with CSS. Feel free to point them to this bug for more information.

    Best regards
    Michael

    <=-=May 5 2009 5:41PM=-=>

    Hi Marcin

    We are working on fixing this now for an upcoming release. However, since it will break existing behaviour, I would like you to provide us some feedback on how fixing it will impact your current workarounds. Could you please get back to me at mrys at microsoft dot com?

    Thanks
    Michael

    <=-=Jun 16 2009…
  12. SP3 Installation and readme unavailable on website

    Able to download the SP3 install executable but unable to access the installation and readme file. It shows up as no longer available. It is an embedded link on the main sp download page

    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 →
  13. ipoint.exe causeses Blue Screen when edit table in SQL 2008 Management Studio

    Edit Table causes blue screen in SQL 2008 Management Studio when ipoint.exe is running.

    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 →

    Upvotes: 1

    <=-=Feb 13 2009 10:38AM=-=>

    Dear customer,

    Thank you for reporting this problem. To help us reproduce this problem, please revert back with the mouse type and the IntelliPoint driver version number. Currently we are unable to reproduce this issue with IntelliPoint driver 6.2 installed on the system where SSMS 2008 Designer was launched.

    Thanks,
    -Karthik

    <=-=May 27 2009 8:31AM=-=>

    Intellipoint driver 6.31.230.0. Also installed and running is the Synaptics ThinkPad UltraNav Pointing Device driver version 11.1.21.2. Computer is a Thinkpad T61. Same issue as reported here. Edit Top 200 Rows = BSOD

    <=-=Jun 3 2011 12:13PM=-=>

    Hi,

    Thanks for writing in to Microsoft.

    There’s another report of a similar issue with IntelliPoint. Given this, I am resolving this one as a duplicate. We will track the issue using the other bug.

    Thank you for your valuable feedback.
    Prachi

  14. XML format file causes bulk insert of wrong data into NOT NULL column

    BULK INSERT into a table with a NOT NULL column behaves very badly when an XML format file is used and there are missing or all-whitespace data values in the source file. No error is raised and incorrect data values are inserted into the table. (Specifically, when there is missing, whitespace, or otherwise invalid data, the NOT NULL column repeatedly receives the last non-null value of the column.

    If a non-XML format file is used, the behavior is not bad.

    This bug is similar to Connect item 405579, however the problem is not as localized as that bug report suggest.…

    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 →
  15. Error scriping procedure when there are nested comments before CREATE PROCEDURE

    If you try to script a stored procedure where CREATE PROCEDURE is preceded by a comment
    that contains nested / /, you get an error message, "Syntax error in TextHeader of StoredProcedure ".

    I saw that this was reported in
    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=178866
    as well, but it was said to have been fixed in SQL 2008, but this does not seem to be
    the case.

    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 →

    Upvotes: 3

    <=-=Feb 26 2009 4:28AM=-=>

    Hi,

    Thanks for reporting the issue.
    The issue was fixed but the fix got reverted due to performance issues before RTM.
    We will fix this in next release.

    Regards,
    Alok

    <=-=Jun 27 2011 4:35AM=-=>

    Hi Erland,

    We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

    You could use many other symbols (quotes, paranthesis, etc.) to demarcate a portion of the comment you want to have nested. For example, you could do:

    /* My comment including “nested comment” and blah /
    OR
    /
    My comment including (nested comment) and blah /
    OR
    /
    My comment including…

  16. ACCESS_VIOLATION crash when using FOR BROWSE on a synonym for a remote object

    Retrieving a browse mode cursor through use of the FOR BROWSE clause in a SELECT statement (or executing a SELECT when SET NO_BROWSETABLE ON is in effect) does not work for synonyms to remote objects. When executing such a query, SQL Server produces a crash dump.

    One notable user of such queries is 2005 BIDS. Using a synonym as part of a stored procedure or view in the designer results in the situation that you will be able to preview the data (when BROWSE is not used) but no columns will be created for components as
    metadata retrieval fails.

    Reproduced…

    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 →

    Upvotes: 1

    <=-=Feb 23 2009 11:15AM=-=>

    Hi,
    Thanks for reporting the problem. We are investigating the issue and get back to you when we reach a resolution.


    Umachandar, SQL Programmability Team

    <=-=Mar 24 2010 11:58AM=-=>

    Hi,
    Thanks again for reporting the issue. This bug has been resolved as duplicate of another one in our system. We are looking at fixing it for the upcoming public cumulative update for SQL Server 2008.


    Umachandar, SQL Programmability Team

    <=-=Mar 24 2010 1:05PM=-=>

    Resolved as duplicate


    Umachandar

    <=-=Jun 8 2011 1:34PM=-=>

    a similar stack is shown at : http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/af2d10db-bc56-43e7-b812-f660ba0052a8/

  17. SSMS Shows incorrect restore chain

    If you restore to an earlier state and continue your regular backup schedule without performing a full backup after the restore, SSMS shows an incorrect restore chain.

    When I run the attached script to recreate the steps followed by the SSMS query I can see that the DatabaseBackupLsn is different. The last differential backup (performed after the Restore) points to the LSN belonging to the earlier backup.

    SSMS should either show the correct Full backup (with the same LSN in the column CheckpointLsn) or not show Differential backups that do not map with the CheckpointLsn of the Full backup.

    As…

    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 →
  18. Materialized Reference Dimension cannot be updated through Dimension ProcessUpdate

    If you have a dimensions linked to a measure group through a materialized reference link and want to refresh it, the ProcessUpdate on the intermediate dimension will not update the materialized reference. Materialized references are refreshed only when the measure group is processed. Non materialized ones works just fine while materialized ones simply show bad data (old, not refreshed) if you leverage the process update on the dimensions.
    This is clear, due to the fact that the relationship is resolved through JOIN made inside the measure group processing and not during dimension processing for materialized relationships, still I think it…

    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 →

    Upvotes: 2

    <=-=Feb 27 2009 11:52AM=-=>

    Hi Alberto — Thank you for your feedback. We will consider your request in a future version. If you think this issue needs to be addressed immediately, please work with your Customer Support contact to resolve the issue.

  19. SqlClient.SqlConnection.Close method does not release server-side resources

    SqlClient.SqlConnection.Close method does not release server-side resources. When a Connection is closed, it is returned to the pool but ADO.NET does not close and does not reset the Connection until the connection is reopened. This means that any resources allocated to the connection are left in use on the server (the server state) is maintained until the next reuse or the connection times out (4-8 minutes later). This reduces performance because of resources not being freed by applications that can no longer access the server-side objects.

    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 →

    Upvotes: 2

    <=-=Mar 6 2009 1:19PM=-=>

    Hello,

    I just wanted to let you know this issue has been closed accidentally. I reactivated it and we will evaluate it again.

    The confusion comes from the fact that the bug has been filed against SQL Server Engine, while it seems to belong to ADO.NET. Please let me know if I�m missing something here?

    Thanks,
    Krzysztof Kozielczyk (Microsoft)

    <=-=Mar 8 2009 4:33PM=-=>

    Hello Bill

    This bug describes the same issue that is described in another connect bug being tracked at http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=383517. Thus we have resolved this bug as a duplicate. Please reactivate if we mis-interpreted this issue and they are not the same issue.

    Thanks

  20. New Query Editor Window in SSMS connected to one server, where as in tool tip text its shows connected to another server

    In SSMS when there is query window connected to a server (say server A) and when a new query window is opened, by default it opens with existing connection (server A). Now when we change the connection of this query to another server (say server B). It is still connected to Server A, which can be verified by running command select @@Servername.

    However tool tip on top left corner of the query editor window shows it is connected to Server B, which it is not not connected to.

    This could me a major issue, because the user may assume that…

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

SQL Server

Categories

Feedback and Knowledge Base