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. cannot re-connect to mirrord database

    i have machine server1 and server2, server3.
    both SQL Server 2005 June2005 installed.
    testdb test database in server1.
    and restored testdb in server2.
    testdb is mirroring database.
    ( principal testdb in server1, mirror testdb in server2, and witness server3 )

    i make a client program.
    this program has "Database=sampdb;Server=server1;Failover Partner=server2" in ConnectionString.
    and network adapter is disable on server1.

    run my client program.
    However, do not re-connect (or redirect ) mirrord database.

    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. 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 11 2005 3:15PM=-=>

    I just tried to copy two stored procedures from a 2000 to 2005 and from 2005 and 2000 and it all worked fine:
    1. You may have an old version (if this is the case, hopefully once you get a new drop it will be fixed) or,
    2. you not have set CopySchema property to true (if this is the case, try setting it and see if it works. If it does great, if it doesn’t then probably you need a new drop)

  3. MSXML DomDocument could not be created

    When installing the APRIL CTP of SQL 2005 Express.
    either alone or via the Visual Studio 2005 beta 2 install the following dialog box is displayed

    MSXML DomDocument could not be created

    SQL 2005 fails to install. I tried uninstalling, reinstalling cleaning many times and still could not get around it.

    Now we have a domain available where I work but as we are away from the office a lot my machine is not part of that, or any domain. When I joined my laptop to the domain and tried again it worked. So I think that either (a) a…

    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. unable to remove dormant sqlserver 2005

    unable to remove previous components of sql express beta 1 et beta 2.
    Problem to install new sqlexpress june beta 2. previous version detected.

    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 →
  5. SQL Server 2000/2005 connection lost

    I have written an application using MS/Access, using an SQL Server 200x database. If running the application sometimes the cursor of an recordset is unexpectedly closed or connection is lost.

    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 19 2005 5:09PM=-=>

    Are you using MDAC?

    <=-=Jul 21 2005 3:33PM=-=>

    Thank you for bringing this issue to our notice. This may be an existing issue that has been fixed. Please apply MDAC 2.8 SP1 and/or Win2k3 SP1 and see if you can repro.

    <=-=Jul 28 2005 7:45AM=-=>

    Once again, thank you for bringing this issue to our notice. This is very likely an existing issue that has been fixed. Please apply MDAC 2.8 SP1 and/or Win2k3 SP1.

  6. SSIS, exporting to flat file column names will not export

    When building a data flow task, source is a view and export is a flat, comma delimited file, the column names will NOT come over as a header row in the flat file.

    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 →
  7. Named Set

    I created a new named set, with the following definition:

    {[Taxo].[Taxo PCH].&[240],[Taxo].[Taxo PCH].&[250],[Taxo].[Taxo PCH].&[261],[Taxo].[Taxo PCH].&[262],[Taxo].[Taxo PCH].&[270],[Taxo].[Taxo PCH].&[281],[Taxo].[Taxo PCH].&[282],[Taxo].[Taxo PCH].&[300],[Taxo].[Taxo PCH].&[400],[Taxo].[Taxo PCH].&[500],[Taxo].[Taxo PCH].&[561],[Taxo].[Taxo PCH].&[562],[Taxo].[Taxo PCH].&[570],[Taxo].[Taxo PCH].&[581],[Taxo].[Taxo PCH].&[582],DESCENDANTS( [Taxo].[Taxo PCH].&[300]),DESCENDANTS( [Taxo].[Taxo PCH].&[300])}

    After processing, I tried to use this set and the as service crashed.

    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

    <=-=Jul 1 2005 2:09AM=-=>

    Thanks for submitting this. We’ll investigate the issue.
    —Analysis Services Team

    <=-=Jul 7 2005 7:27PM=-=>

    Hi Joos, Thank you for reporting this issue. We are not able reproduce this issue using the information provided in the bug. It will help us a lot if you can send the Analysis Services project and the underlying relational database. You can send me an email (srinin@microsoft.com) if you have any questions.
    Thanks,
    Srini.

    <=-=Jul 14 2005 5:33PM=-=>

    Hi Joos, Thank you for reporting this issue. We are not able reproduce this issue using the information provided in the bug. It will help us a lot if you can send the Analysis Services project and the underlying relational database. Thanks, Srini.

  8. Cannot modify a table when it is open

    When a table is open with a query, I am not able to modify 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: 4

    <=-=Jun 30 2005 8:09AM=-=>

    Thank you for your bug report regarding modify and open table. This behavior is fixed in the June CTP release.
    Bill Ramos

    <=-=Jul 6 2005 12:45PM=-=>

    Hello there~
    Thanks for reporting this issue [Cannot modify a table when it is open]

    This issue has been fixed in June CTP.
    Thanks
    [Venkat]

  9. No reference to SQL Server

    No reference to SQL Server in Programs after sucessfully installing SQL Server 2005 Beat 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 →
  10. Cannot change schma from UI

    You cannot change the schema for a user through the UI. It looks as if you can, but if you save, and then look at the user again, nothing has changed. And if you select "Script", you are told "There is nothing to be scripted".

    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. SQLCMD crashes on multiple COMPUTE BY clauses

    When you run a query with multiple COMPUTE BY clauses, SQLCMD crashes. The problem happens both when I connect to SQL 2005 and SQL 2000 and is thus not an engine bug. Furthermore, the issue does not happen with my own client program that uses SNAC, so this appears to be SQLCMD specific.

    Credits to Paul Nielson and Tony Green who produced the original repro.

    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 →
  12. 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 →
  13. 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 →
  14. Unable to install sql server 2005, fails at the end

    Fails to install at the end, I allowed the bug report to be sent to Microsoft but can't remember the details.

    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

    <=-=Jun 22 2005 8:27AM=-=>

    We’d need more info to investigate this. Specifically, we’d need Setup logs to proceed. If you have them, please reopen this bug and attach them. Otherwise we’ll look at the Watson failure but not correlate it to this report.

  15. Mgmt Studio gets unhandled exception in Schema changes report

    Tihs is an issue for which I have difficulties to provide a repro. I cannot submit the script for the database it happened with, at least not in this open forum. But since it forced me to kill Mgmt Studio, I still like to report it.

    I was looking at the "Schema Changes History" in this database that I recently had built from script. This is a large database with over 800 tables and 3700 stored procedures. I wanted to look at the entry for some stored procedure, and clicked the Plus icon for it. When nothing happened, I kept…

    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

    <=-=Jun 21 2005 7:27AM=-=>

    Erland,

    Thanks for reporting this. I was not able to repro this issue. It’s possible that we can’t repro this because it was fixed in the meantime as some problems related to report rendering have been fixed since the build you have went out. If you see it again, can you save the contents of the unhandled exception message box and add it to this bug?

    thanks,
    Jesse Hersch

    <=-=Jun 21 2005 12:03PM=-=>

    Erland,

    Thanks for reporting this. I was not able to repro this issue. It’s possible that we can’t repro this because it was fixed in the meantime as some problems related to report rendering have been fixed since the build you have went out. If you see it again, can you save the contents of the unhandled exception message box and add it to this bug?

    thanks,
    jesseh

  16. Several scripting issues

    Several issues with scripting. (All tasks /Generate scripts in
    Mgmt Studio.) There are two zip archives, one for a very simple
    database scripttest, and for a somewhat more complex database
    abaperls. Different exhibits in the two databases.

    In this text GSDO refers to the scripting option "Generate Scripts for
    Dependent Objects".

    scripttest.zip includes:
    - scripttest-create.sql - how to create the database.
    - scripttest.jpg - my scripting options.
    - scripttest-script.sql - the generated script.

    abaperls.zip includes:
    - abaperls-create.sql - how to create the database (you will have to
    add CREATE DATABASE and USE)
    - abaperls-script1.jpg/sql - First set of scripting options…

    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 1 2005 2:39PM=-=>

    All issues should be fixed.

    <=-=Jul 26 2005 1:57PM=-=>

    postponed

    <=-=Jul 27 2005 3:03PM=-=>

    Hello there
    Thanks for reporting this issue [Extra USE statements when scripting – 390395]

    Our feature team has decided to fix this in a future release.

    Thanks for your time
    [Venkat]

    <=-=Jul 30 2005 3:57PM=-=>

    Could you please clarify what you have fixed and what you have postponed?

    <=-=Aug 1 2005 4:04PM=-=>

    Hi Erland,
    Thank you for your bug report regarding the various issues with the generate script wizard. We are postponing the fix needed to correct the problem with the multiple USE statements as part of your 4th point in the bug report. All of the other items should be fixed in the next CTP release.
    Bill Ramos

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

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

    <=-=May 29 2006 12:52AM=-=>

    Thank…

  17. Multi-value doesn't seem to work

    multi-value parameters do not seem to work. Selecting all values and running the report does work, bringing back all values; but selecting only one value seems to bring back all values again, not just the value that was selected. This happens both in VS 2005 designer and report manager.

    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. Unknown file type error during installation

    I am getting unknown file type when trying to install the beta version of SQL Server 2005 Developer Edition. I got the copy at TechEd 205.

    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

    <=-=Jun 20 2005 8:51AM=-=>

    Thank you for reporting the problm. We need more information to help us troubleshoot the probelm. When are you seeing the error (e.g. when you put in the CD, during the setup dialogs, when the files are being copied, etc)? Does the error msg tell you which file is an unknown type?

  19. Error trying to view reports about database in SQL Server Management Studio

    I'm receiving an error when trying to view any reports whiled drilled down to the database level in the SQL Server Management studio window. I haven't installed the Reporting Services, mentioned because it might be related. But when I try to view a report in SSMS I get the following error. "The report definition for report 'Databases.rdl' has not been specified Object reference not set to an instance of an object."

    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

    <=-=Jun 20 2005 4:33PM=-=>

    Thank you for reporting this. This issue has been fixed already in internal builds, you will have the fix for the RTM release.

    <=-=Jun 20 2005 6:27PM=-=>

    Microsoft comments: Thank you for reporting this. This issue has been fixed already in internal builds, you will have the fix for the RTM release.

  20. Unable to use CONNX OLE DB driver with SQL 2005

    Unable to use CONNX OLE DB driver for DTS

    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

    <=-=Jun 17 2005 11:51AM=-=>

    We need more info. What’s the backend data source type? Is it SQL Server? Can you give us your contact email?

    <=-=Jun 27 2005 1:03PM=-=>

    We really need more information before we can pursue this further. Please provide a adequate information to resolve the issue.

    <=-=Aug 11 2005 7:31PM=-=>

    The backend is a CONNX Data Dictionary. So the Data source is CONNX (CDD) file. We are trying to import them to SQL Server 2005. This works in SQL Server 2000 using DTS. That is the current work around for the problem.

    My email id is chaksreddy@hotmail.com

    -Thanks
    Chakri

    <=-=Oct 31 2008 12:11PM=-=>

    We have now closed this issue, if you require further assistance, please let us know.

    Thanks

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base