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. Unknown Software exception

    When first booting my machine I get a "Unknown Software exception 0xc06d007e at location 0x7c81eb33.

    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

    <=-=Apr 22 2005 8:29AM=-=>

    Please reactivate and attach the log files from:
    Program Files\Microsoft SQL Server\90\Setup Bootstrap\log\files\*.log. You can zip the files before attaching them.

    <=-=Apr 26 2005 8:49AM=-=>

    There really isn’t enough information to troubleshoot this issue. I suggest you make sure your machine is totally clean of SQL Server, Visual Studio and .NetFX Betas and CTPs. Once you’re sure it’s clean try reinstalling.

    <=-=Apr 27 2005 8:34AM=-=>

    You reactivated the bug – do you have new information that can help with investigating the issue?

  2. Database Mirroring - Pressing OK in database properties dialog box breaks mirroring

    In sqlwb (ssms), using database properties dialog box (right click on the database) configure database mirroring through the UI. After the mirroring is showing as synchronized exit this by pressing the OK button.
    ssms is gets stuck.

    My versions:
    Copied from ssms help about
    Microsoft SQL Server Management Studio (expires in 349 days) 9.00.1187.00
    Microsoft Analysis Services Client Tools 2000.090.1187.00
    Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpspsp2rtm.040803-2158)
    Microsoft MSXML 2.6 3.0 5.0 6.0
    Microsoft Internet Explorer 6.0.2900.2180
    Microsoft .NET Framework 2.0.50215.312
    Operating System 5.1.2600

    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

    <=-=Jul 25 2005 4:39PM=-=>

    We have made a lot of changes from build CTP 15. We can not repro it in our newer build. And also there is a QFE in DB mirroring and Database properties dialog. If you find this problem again on newer version, please let us know.

    Thanks

  3. Unknown properties generated by Package Configuration Wizard

    The Package Configuration Wizard in Integration Services does not properly create the EnumeratorProperties for the Foreach Loop Container

    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 →
  4. Copy Paste Stop working in SQL 2005

    After using Server Management studios editing a script, sometimes copy and paste stop working. I can't use keystrokes or a right click on the mouse. If I go to other applications it works fine. If I close the script and not Server Mgmt and reopen it again, it still does not work. I have to close all scripts and shutdown the app and restart 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: 5

    <=-=May 1 2006 4:28PM=-=>

    Hi Eugene,

    Thanks for taking the time to log this issue. So far we have not been able to repro this issue in our lab environment.
    I suspect that it may be something specific to your configuration or hardware. (Can you let us know what your config is?)
    Can you also check your free swap space and other resources on your system and determine if they are constrained?
    Also check the Windows event log and see if there are errors in there that may give us a clue as to what is failing.

    Thanks,

    Terrence

    <=-=May 23 2006 1:40PM=-=>

    Hi Eugene,

    I am closing this issue as a “no repro” on our end.

    Please let us know if this happens to you again.

    Thanks,

    Terrence Nevins
    SQL Server Program Manager

    <=-=Aug 25 2010 12:46PM=-=>

    I’m seeing the same behavior. Windows 7 64-bit & SQL

  5. SSAS Error "Internal error: An unexpected exception occured." when creating aggregations

    This error occur on Microsoft Visual Studio 2005 when working with Analysis Services cubes and creating aggregations.

    With this error no aggregation at all is created, making the cube VERY slow.

    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. SP1 Failure

    Attempting to install SP1 reports a failure on Database Services, Analysis Services and Reporting Sevices - also fails on Windows 2003 with SP2 installed.

    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

    <=-=Apr 24 2006 9:24AM=-=>

    Thank you for your feedback. For us to investigate this problem, could you supply us with the Service Pack 1 log files located at
    Windir\Hotfix?

    Thank You,
    Peter Saddow

    <=-=Apr 26 2006 9:24AM=-=>

    Thank you for your feedback. For us to investigate this problem, could you supply us with the Service Pack 1 log files located at
    Windir\Hotfix and reactive this issue.

    Thank You,
    Peter Saddow

  7. underline should be treated as a part-of-identifier character

    underline should be treated as a part-of-identifier character, so that double click on a sql identifier within sql pane within query editor in sql mgmt studio select complete inentifier (this also apply to ctrl-left and ctrl-right which are supposed to jump to start and end of words, identifiers included

    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

    <=-=Aug 26 2005 4:52PM=-=>

    Hi Pgklada,
    Thank you for your suggestion regarding the underline character being treated as part of the indentifier. We will consider this for a future release.
    Thank you,
    Bill Ramos

    <=-=Aug 29 2005 11:24AM=-=>

    Hi pgklada,
    After further investigation, it looks like we have fixed this problem already. it will be available in our next customer technology preview release.
    Thank you,
    Bill Ramos

  8. Generated script of a view from SQL Server 2005 Management Studio Express CTP with the 'Script for Server Version' will not run in

    Script of a view generated with 'Script for Server Version' to 'SQL Server 2000' option using 'Generate Scripts...' from SQL Server 2005 Management Studio Express CTP will not run in SQL Server 2000. The script is generated with:

    IF NOT EXISTS (SELECT * FROM sys.views WHERE objectid = OBJECTID(N'[dbo].[v_GroupMembers]'))

    and results with "Invalid object name 'sys.views'." when executed in SQL 2000 Query Analyzer

    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

    <=-=Mar 24 2006 9:32AM=-=>

    Thank you for your bug report. We will investigate this for a future service pack.

    <=-=Mar 28 2006 8:44AM=-=>

    Quick update. We are placing this bug report under consideration for SP2.

    <=-=Apr 11 2006 12:04PM=-=>

    Thank you for reporting this. This issue is fixed in the SP1 release of SQL Server Managment Studio Express.

  9. Location of precedence contraints not saved with SSIS packages, and no auto arrange

    When designing SSIS package control flows, one can move the precedence contrains
    around to create an easy to view layout, where the precedence constraints do NOT
    overlap tasks (which looks confusing.)

    This arrangement of precedence constraints is however not saved with the package -
    after saving & reopening the package all precedence constraints goes back to a default
    position, usually overlapping tasks.

    Since the default layout is so bad (the overlaps), and there is no "auto arrange" that
    does a better job, this is to me a bug.

    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: 5

    <=-=Sep 23 2005 4:28PM=-=>

    Good comment. We’ll look at this in next version

    <=-=Dec 7 2005 2:20PM=-=>

    We could not repro this problem with RTM release of SQL Server 2005. If you can repro this, could you please provide more details and possibly attach the package that causes this behavior?

    <=-=Feb 15 2006 1:40PM=-=>

    Not Able to Repro on RTM or SP1
    The layout always remeber the position of the precedence constraints

    <=-=Nov 14 2008 3:32PM=-=>

    I believe this has to do with 1 a diagram that does not fit on the page (therefore has up/down and left/right scrollbars), 3 little margin space around the edges of the diagrams, and 3 tasks that are placed fairly close together. If tasks have sufficient space between them, then it does not act up this way.

    <=-=Mar 29 2010 2:53PM=-=>

    Here are my steps:
    � Created 25 Data Flow Tasks
    �…

  10. Error then try to use output on table with computed column and instead off trigger

    Then try to use output clause in DML operator on table with computed column and enabled instead off trigger on same DML, the server rise error: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

    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. Full-text indexing crashes

    Creating a full-text index failed & crashed the system. Please just check this - it may be fixed by now, but I've used up all my available computers with different VS 2005 versions.

    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

    <=-=Oct 18 2005 11:24AM=-=>

    Hello Nathanael

    Thank you for reporting this issue. In order to investigate this behavior, we need a little more information from you:
    1. What SQL Server edition are you using (Express, Workgroup, Standard, or Enterprise) and which version/build (June CTP, September CTP)?
    2. You wrote: “Creating a full-text index failed & crashed the system” and Steps to Reproduce=“Go through the full-text index process”. Could you please provide some more detailed steps that led to this failure so we can reproduce this problem?

    Thanks.

    SQL Server Full-Text Search Team

    <=-=Nov 2 2005 2:52PM=-=>

    We’re not able to reproduce this problem.

  12. User Mapping doesn't always work when adding a server login

    The problem occurs when trying to set up user mappings for a new login. If the user is added to more than one database, and is added to the same role on those databases, then the role allocation only works for the first database selected.

    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

    <=-=Oct 25 2005 8:36AM=-=>

    Hi Sam,
    Thank you for your bug report regarding the database mapping UI. We will investigate this and address it in a future release.
    Bill Ramos

    <=-=Mar 31 2006 7:40AM=-=>

    Quick update. We are placing this bug report under consideration for SP2.

    <=-=May 3 2006 9:00AM=-=>

    Thanks for your valuable feedback. We are unable to reproduce the issue. If you see this again then please get back to us.

  13. [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x04A3AD14.

    Using the Visual Studio product to modify/test dts package that run daily on SQL Server 2000, I receive the following error:
    [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x04A3AD14.


    1. what component?

    2. the only file name referred to is a file that is validated(correctly) in a later step

    The point being that this is an initialize global variables step.

    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 23 2006 11:56AM=-=>

    Not able to repro this issue.
    I try to repro using:
    1) Migrated the DTS package to SSIS. Migratd, edit and execute correclty.
    2) By using the Exec2000packageTask in BIDS able to edit and execute the DTS2000ActiveX package
    Did you migrate the DTS 2000 ActiveX package?
    Are you edit the ActiveX task in BIDS using the Exec2000PackageTask
    Thanks

  14. Instalation of Microsoft SQL Server 2005 Express Edition

    My instalation process has failed. SQL Server 2005 Express Edition, which is available with Visual Studio 2005 Beta 2, can not be installed on my computer. Even after my installation of VS 2005 was completed i was not able to add SQL Server - the same error occurec.

    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. Pressing F1 after Clicking an Object in Execution plan displays an online J# Help Topic

    Pressing F1 after Clicking an Object in an Execution plan displays an online J# Help Topic. Specifically, http://msdn2.microsoft.com/en-us/library/ms246373. The topic isn't relevant to SQL Server Execution plans, and by definition, didn't open the help topic that is relevant.

    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 →
  16. 'select database' combobox does not echo 'non-existant server' error on 'new connection window' on Data->ShowDataSources

    'select database' combobox does not echo 'non-existant server' error on 'new connection window' on Data->ShowDataSources

    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

    <=-=Aug 31 2005 9:48AM=-=>

    Hi pgklada,
    Thank you for your bug report regarding Data-ShowDataSources. We could not reproduce the problem in SSMS. If you are actually commenting on Visual Studio behavior, please re-file a bug report under VS.
    Thank you,
    Bill Ramos

  17. Reporting Services WMI Provider Code Error

    While continuing to work on the latest version of my WiredNav control using VS 2005 Beta 2 and SQL Server 2005, I found an "unchanged" method that now causes an exception. The method is based on the example WMI Provider code for the MSReportServer_ConfigurationSetting Class. My method and the example work fine with VS.NET 2003/SQL Server 2000/Reporting Services 8.0.743.00 but when I use VS.NET 2005/SQL Server 2005/Reporting Services 9.00.1116, I get a ManagementException: Invalid namespace.

    Does this have something to do with the path of the RSReportServer configuration file?
    For VS.NET 2003, the RSReportServer configuration file (rsreportserver.config) is located in…

    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

    <=-=Oct 25 2005 11:32AM=-=>

    Unfortunately, we had to move the namespace. The correct namespace is now: \root\Microsoft\SqlServer\ReportServer\v9.

    <=-=Oct 25 2005 6:14PM=-=>

    I ran the test again using the example under the MSReportServer_ConfigurationSetting Class at http://msdn2.microsoft.com/en-us/library/ms154648, which has the new namespace location \root\Microsoft\SqlServer\ReportServer\v9, and I still get the Invalid Namespace exception. How does the “\root\Microsoft\SqlServer\ReportServer\v9” work? Can I create an instance of the MSReportServer_ConfigurationSetting Class directly using the namespace?

    <=-=Oct 27 2005 10:46AM=-=>

    I got the example under the MSReportServer_ConfigurationSetting Class at http://msdn2.microsoft.com/en-us/library/ms154648 to working using namespace \root\Microsoft\SqlServer\ReportingServices\v9 not \root\Microsoft\SqlServer\ReportServer\v9. However, this only works with the Management Path of MSReportServer_Instance used in the example. It does not work for MSReportServer_ConfigurationSetting or MSReportManager_ConfigurationSetting. I get an object Not Found exception. This means that the old VS 2003 example for the MSReportServer_ConfigurationSetting Class does not work even after changing to the new namespace. Something is not right here.

    <=-=Nov 8…
  18. Exception thrown Using SetDefaultInitFields on Column with SqlServer 2000

    When using SMO and SetDefaultInitFields on Smo.Column when connecting to MSSQL 2000, SMO Throws an exception while populating the object: Unkown property XmlSchemaNamespace.

    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 →
  19. localhost/reports problem after 9.00.2040 install

    I just installed SQL Server 2005 9.00.2040 (March CTP) Enterprise Edition Reporting Services on my W2K (SP4) box.

    I tried 'localhost/reportserver' without problems, but 'localhost/report' gives me this:

    The XML page cannot be displayed
    Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


    A name was started with an invalid character. Error processing resource 'http://localhost/reports/'. Line 1, Position 2

    <%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePag...

    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

    <=-=Apr 28 2006 12:52PM=-=>

    To investigate this issue further, can you provide more information on the specific steps you used to install? Was IIS installed before you ran SQL Server 2005 setup? Thanks.

    <=-=May 19 2006 5:48PM=-=>

    To investigate this issue further, can you provide more information on the specific steps you used to install? Was IIS installed before you ran SQL Server 2005 setup? Thanks.

  20. arithmetic overflow while in the Tasks Summary Report

    arithmetic overflow while in the Tasks Summary Report.

    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

    <=-=Feb 1 2006 4:28PM=-=>

    Hi Brian,
    Thank you for your feedback. Would it be possible for your to send the dump for this crash? Please attach to this feedback/bug.
    Thanks,
    Ramesh Singh

    <=-=May 2 2006 3:00PM=-=>

    The repro steps provided do not repro the issue on SQL Server 2005 SP1. Could you please provide additional repro steps or configuration settings if this is still an issue for you in SP1?

    <=-=May 30 2006 12:04AM=-=>

    This bug is not reproducable on Sql server 2005-RTM and Sql server 2005-SP1. Could you please provide additional repro steps or configuration settings if this is still an issue for you in SP1?

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base