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. SQL 2005 breaks COM+ Services(DTS) on Windows XP Professional

    "My Computer" in Console Root/Component Services/Computers is shown with a "down" icon. DTS service will NOT start.

    This is the error returned when trying to start the DTS service. This is the error in the event viewer.

    The Distributed Transaction Coordinator service terminated with service-specific error 3221229584 (0xC0001010).

    The error dialog reports error code -1073737712

    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 27 2005 11:08AM=-=>

    Thank you for your feedback. If you are having problems with COM+ it is probably unrelated to SQL Server 2005, as we are unable to repro this failure in our labs. Have you tried this to repair MSDTC? Start a command window and type “msdtc -resetlog”.

    If problems persist please contact CSS (previously named PSS) for support with the MSDTC service.

    <=-=Aug 27 2005 11:16AM=-=>

    Thank you for your feedback. If you are having problems with COM+ it is probably unrelated to SQL Server 2005, as we are unable to repro this failure in our labs. Have you tried this to repair MSDTC? Start a command window and type “msdtc -resetlog”.

    If problems persist please contact CSS (previously named PSS) for support with the MSDTC service.

  2. Query designer modifies simple, useful query

    Query designer changes a correlated subquery into a non-correlated subquery, completely changing the meaning of a query.

    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

    <=-=Aug 25 2005 9:08PM=-=>

    Hi Steve,
    Thank you for your bug report. I’ve forwarded it on to the Visual Database Tools team to investigate.
    Bill Ramos

    <=-=Aug 29 2005 1:00PM=-=>

    Hi Steve,
    Thank you for your bug report regading the modification of this query. This problem was fixed as part of an earlier fix and should be ok for the next CTP release.
    Bill Ramos

  3. Internal Query Processor Error when trying to insert XML data into remote MAX column

    Credits for finding this issue goes to Bryan Myers.

    When you try to insert a value from an XML document using value into an nvarchar(MAX) column in remote table, this fails with Internal Queryr Processor Error.

    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 23 2005 10:28AM=-=>

    Erland, thanks a lot for reporting the problem and providing great repro. We were able to observe the problem on IDW 15, but DOES NOT on current builds. So it should be fixed in the next available beta refresh.

    <=-=Sep 18 2005 1:47PM=-=>

    Tested in CTP16. It works now.

  4. Transfer Objects Fails - Source Table Does not exist

    Set up Transfer object to copy one table from a source db to a destination db. Under the Destination Copy Options, wich should be Source Copy Options, under (Collection) I select the tables I want to copy from the source to the destination. When I run the package I get the following error:

    Error: 0xC002F363 at Transfer Test Tables, Transfer Objects Task: Table "FiscalMonth" does not exist at the source.
    Task failed: Transfer Test Tables.

    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

    <=-=Aug 23 2005 9:08AM=-=>

    Does the table exist at the source? Is the table name correctly spelled? Do you have the package? If so, will you send it with the script to build the table you’re trying to transfer? Is this reproduceable with other tables? What version of SSIS are you using?

    <=-=Aug 24 2005 2:12PM=-=>

    Which version of SQL Server is being used? Probably if a newer version is used this problem may be solved.

    This bug is not reproable as described. I need more info: Which version of sql server are used for source and destination? Are you choosing all tables, or a set of tables? Are you setting copy schema? … It is better to have the package attached. But I could copy a table from a source to a destination just fine.

    <=-=Jan 18 2012 12:58AM=-=>

    Please re-open.

    This error msg shows when trying…

  5. FTP Connection not Found

    After creating an FTP Task, and referencing an FTP connection, the system reports the connection cannot be found

    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. Allocation Error with Multiple Cell Updates and USE_WEIGHTED_ALLOCATION

    Making multiple updates to the same cell incorrectly spreads the updates to the children. The first time the parent cell is changed, the spreading is correct. If you then change the parent again, the spreading is wrong. For example, halving the parent's value does not halve the childrens' values when using USEWEIGHTEDALLOCATION.
    Also, after the first update, NULL cubes are replaced with zeroed cells. That is, the children that should be NULL are now allocated a value of 0.

    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. '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

  8. SQL Server Express (April OR June) Refuses to install!

    I have tried many different ways, on 2 separate machines, but cannot get either AprilCTP or JneCTP to install.

    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 30 2005 1:08PM=-=>

    Thank you for trying SQL 2005 and I am sorry you are having trouble.
    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.
    Try to ensure that you only provide logs from the run that is failing and first clean out the older logs.

  9. Add File as Link to Project is SSMS doesn't work

    The add existing file option on the project in SSMS allows files to be added as links, this doesn't work nothing happens.

    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

    <=-=Aug 22 2005 8:36AM=-=>

    Hi Simon,
    Thank you for your bug report regarding adding a file as a link to a SSMS project. We are deferring this issue to a future release.
    Thanks,
    Bill Ramos

    <=-=Aug 22 2005 11:53AM=-=>

    Are you therefore removing the Add as Link option?

    <=-=Mar 28 2006 9:32PM=-=>

    Hi Brent,

    Based on the feedback we are hearing from the community we are stepping up our effort to address this issue for the next release.

    Thanks for your support and interest in this area.

    Terrence Nevins
    Program Manager SQL Server

    <=-=Apr 14 2006 1:24PM=-=>

    Hi Simon, I just tried this against RTM and I was able to add a file as a link. The file remained in it’s original location and all updates through Management Studio updated the file in the original location. If you are still experiencing this problem with RTM please reopen the…

  10. Second deselection of column, on deselects column for some events.

    Open a default trace. Click on Stored Procedures and Select evnet Category. Now right-click ClientProcessID and deselect it. Works fine. Next try to unselect ApplicationName. But this time the columns is only unselected for some events.

    Deselecting columns in some order shows that it is only the first column that is deselected that is handled correctly.

    The workaround is to deselect per event.

    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

    <=-=Sep 5 2006 2:07PM=-=>

    Thank you for reporting this issue. We were able to reproduce the problem and we will investigate how to fix it.
    At this point I can suggest a workaround – you should expand the category before selecting all events in it. The issue does not happen in that case.

    Regards,
    Maciek Sarnowicz

    <=-=Nov 29 2007 8:46PM=-=>

    Thanks for reporting this defect.

    Closing this as duplicate of another bug that tracks this issue for the next release.

    Thanks,
    Gops Dwarak

    <=-=Nov 30 2007 1:33PM=-=>

    And next release is SQL 2008? Or is it Katmai+?

  11. Adding event in Profiler, does not add new columns

    Say that I start from the Standard trace definition, check Show all Events, and the add the Objects events. I would sort of expect that columns that are relevant for these objects are now automatically included. They are if I first have check Show All Columns.

    Maybe the behaviour make sense, if the I idea is that I have already made my mind up about which columns to display, but if'm just working from the Standard template (which users will do 95% of the time), then I haven't.

    Maybe there should question "This event can populate columns you have not…

    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

    <=-=Aug 22 2005 10:52AM=-=>

    Thanks for reporting this error. By default, all important columns across all events are visible (without checking the Show All Columns check box). When you check the Show All Columns check box, we automatically select all columns if you select an event.

    I am keeping this bug open and in the next release we will see if there is better usability that we can offer.

    <=-=Nov 26 2007 10:27PM=-=>

    Closing this as duplicate of another bug that tracks this issue for the future release.

    Thanks,
    Gops Dwarak

    <=-=Aug 30 2009 10:31PM=-=>

    Hi Erland,

    Thank you for using Profiler and reporting the bug. I understand and agree with what you reported on – a more complete set of event columns (if not all) should be included as part of the standard tracing template. Other templates (such as TSQL_Replay) are better though still leave out a…

  12. TOP clause does not work with OPENQUERY()

    A select statement with a top clause selecting from an openquery returns all rows instead of the number declared by the top clause.

    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. Cannot Delete, Modify Rows in the Query Window

    This Bug is similar to FDBK20383 except that it occurs when there are no duplicate rows.

    When trying to update a field or delete a row in the query window I get the message:

    No row was updated.

    The data in row 2 was not commited.
    Error Source: Microsoft.VisualStudio.DataTools.
    Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows).

    Correct the errors and retry or press ESC to cancel the change(s).

    When the desired action is performed by typing the SQL Statement then the desired result is acheived. ie:…

    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. Can't activate ReportServer

    I am unable to activate my report server. I tried installing/reinstalling, rsactivate, rskeymgmt, rsconfig, etc. Nothing seems to work.

    I've attached the report server log files from the failed activation.

    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. Cannot add a database user to a database role if the name contains a dash.

    Unable to add a database user to a database role when the name contains a dash.

    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. New Job window doesn't let you enter space

    When creating a schedule for a new backup job, Management Studio doesn't let you to enter a space into the job name and the schedule name textboxes.

    When you press space the cursor jumps back to the first position.

    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 →
  17. Exception when refreshing Object Browser

    When refreshing the Object Browser the following exceptions occures:
    System.ArgumentException: Item has already been added. Key in dictionary: '(Icon)' Key being added: '(Icon)'
    at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
    at System.Collections.Hashtable.Add(Object key, Object value)
    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.AddIconToImageMap(TreeNode node)

    see full log in the attachment.

    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. Incorrect reference to non-existing view sys.languages.

    On ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a616fce9-b4c1-49da-87a7-9d6f74911d8f.htm
    in the first table, in the centre column, a view sys.languages is mentioned. There is no such view. It should be sys.syslanguages.

    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. MSSQLService will not start since applying latest security fixes

    I just applied the latest secrurity patches mandated by corporate (I work for MSFT.) I am running the June CTP. After applying them, my MSSQLServer instance will not start. All other services (and I have them all installed) seem to function just fine. When I go to services to start, I get this message -> The SQL Server (MSSQLSERVER) on the local computer started and then stopped. Some services stop automatically if they have no (blah blah).

    I have 4 messages in my event viewer one regarding spawning FRunCM, one regarding the network library not starting because of an internal…

    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 12 2005 2:11PM=-=>

    Diane,

    I see the bug you reported this morning. Can I get access to your machine? It would also help if you are able to turn on BID trace.

    Thanks,
    Xinwei

    <=-=Aug 16 2005 8:04AM=-=>

    Diane,

    We were unable to reproduce this in house and you’ve shared with us that you have lost the repro. We strongly suspect that there is a misconfiguration or missing security dll on your system. If you are still having concerns with AS, please go ahead and file a different bug to follow up there.

    Thanks.

  20. Problem installing April CTP and July CTP of SQL Server 2005 Express Edition if multiple OS is installed

    I tried to install VS.NET 2005 Express and Web Developer Express and both failed because SQL 2005 Express can not be correctly installed. I tried to install SQL 2005 Express the April CTP and July CTP then, they both failed. I could install them on some other machine without any problem, so I think that it is because I installed two OS's on this machine.

    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