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

  2. 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 →
  3. 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 →
  4. '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

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

  6. 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…

  7. 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+?

  8. 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…

  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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.

  17. 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 →
  18. Getting index properties for table in Management Studio is too slow

    Getting index properties for table in Management Studio is too slow.
    In my Pentium-4 3GHz 512Mb it requires about 1 minute to open index properties window.

    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. Impossible to view execution plan when connected to MSSQL_2000

    When Management Studio is connected to MSSQL2000 is impossible to examine graphical execution plan for big query (when query is more then 50 strings). See print screen file in attachement.
    When Management Studio is connected to MSSQL
    2005 everything is ok.

    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 →
  20. Operators *= =* works as inner join at the compatibility level less than 90

    Operators = = works as inner join at the compatibility level less than 90.
    At the compatibilty level 90 those operators throws error according to BOL.
    But at the compatibilty level 80 (or 70) they work as simple inner join.

    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