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. CTP5 - Error when editing Backup Task in Maintenance Plan on 1/16/2008

    When the computer date set to 1/16/2008, trying to edit the Backup Task in Maintenance Plan, I'm getting the following error:

    Value of '1/16/2008 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
    Parameter name: Value (System.Windows.Forms)

    After I change the computer date to 1/17/2008, it works 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 →

    Upvotes: 0

    <=-=Apr 16 2008 8:37PM=-=>

    Hi Ayad,

    This issue has been fixed, and we feel it is fixed in ctp6 itself. Kindly let us know if you think otherwise. Thank again for reporting this issue. We appreciate your concern and effort in helping us improve the quality of SQL Server.

    Regards
    Vinod

  2. MSFT-MSO: System SPs and Functions firing a lot of 'Deprecation' events in profiler, makes it tough to identify the events fired b

    System SPs and Functions firing a lot of 'Deprecation' events in profiler and this makes it extremely difficult to identify the events fired by user created objects.

    My objective was to run a trace and figure out if we're referring/using any objects that are going to be deprecated - But system objects firing a lot of deprecation event is too annoying. What's even more spamming is that, the very frequently used SPs like sphelptext, spdepends do fire lot of this event.

    I think it would be great if we start using the new replacements in our system SPs,…

    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 22 2008 11:31AM=-=>

    Hello,

    Thank you for sending us your feedback. We are aware of this issue and are working on a solution for this. However, it is quite tricky to solve this. We can either spend a lot of efforts in the current release (SQL Server 2008) and get rid of all internal dependencies or enhance our deprecation messages to not fire if the usage is internal.

    Once we decide on the solution, we will get back to you. If you have any suggestions, feel free to send them to us.

    Thanks,
    -Vineet Rao.

  3. Save Excel 2007 workbook without the data

    People with administrator rights built report with Excel 2007 base on the SSAS datasource. the report contain only a pivottable and the option "refresh data when opening file" is enable.

    The security is fixed on the cube using Roles. When people with less rights than administrator are openning the report, it takes 1 second to open the report, that means they should watch secure data ( even more than 1 second by printscreen ... ).

    I assume there is a way to save an Excel report without the data, or a different workaround to solve this security bug ... If…

    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

    <=-=May 23 2008 9:16AM=-=>

    Thanks codou for reporting this issue and apologize it taken us bit while to come back to you with an answer.

    Unfortunately you need to file this request with Office team that is responsible for Excel behavior.

    The Analysis Services Team

    <=-=Jun 23 2008 7:57AM=-=>

    Thanks for your reply,
    could you let me know the contact of the Office team ?
    Are there a connexion for Office Excel ?

  4. Unable to Browse Cubes in SSMS 2008

    When attempting to browse a SQL 2008 cube using the SQL Management Studio 2008 client, we receive an error in the main browsing area:

    Class not registered (Exception from HRESULT: 0x80040154 (REGDBECLASSNOTREG))

    Previously, attempting to browse a SQL 2005 cube also returned a protected memory error, but I can no longer recreate this (related to Connect Bug 292484.) Now, it gives the same error message as above.

    This error message occurs for our entire team.

    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

    <=-=Jan 7 2008 9:43AM=-=>

    Thank you for reporting this defect, we are fixing it for the release of AS2008. Meanwhile I resolved this bug as a duplicate of another older defect.

    <=-=Dec 8 2010 1:34PM=-=>

    It’s December 2010. I just installed SQL Server 2008 R2. This STILL happens in SSMS.

    <=-=Mar 11 2011 7:02AM=-=>

    Now March 2011 and we did ran into this as well (SQL Server 2008 R2). Could you kindly elaborate what the fix should be ?

  5. Full Text Installation Failure

    Installation of SQL Server 2008 November CTP on Win 2008 RC1 leaves full text capability disabled.

    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 18 2007 7:24PM=-=>

    Sorry you are hitting this issue and thanks for reporting it. When you say “Create Database screen” what are you referring to?

    <=-=Dec 19 2007 4:00AM=-=>

    Open SQL Server Management Studio, right-click Databases in Object Explorer, select New Database

    <=-=Dec 20 2007 6:19PM=-=>

    Sorry I am unable to reproduce the problem. Can you please attach the setup logs which are by default located under “Program Files\Microsoft SQL Server\100\Setup Boostrap\Log\”?

    <=-=Dec 22 2007 6:40PM=-=>

    Screen shots and log files attached

    <=-=Jan 19 2008 11:34PM=-=>

    I apologize for the delay. We have been unable to reproduce this problem. After install we are able to successfully create a database with Full-Text enabled. Can you try running the following SQL statement and let me know if this returns 1 (indicating that Full-Text is installed):
    SELECT FULLTEXTSERVICEPROPERTY

    Also do you see the SQL Server Full-Text Search service…

  6. 2008: DUTT: Does not restore master DB or restore original logins for replay

    The master database was backed up from production databases in the previous release of DUTT for the purpose of extracting logins information. Profiler replays transactions in the context of the user connection Profiler is connected to SQL Server with, not the actual logins in the captured trace file. This works fine in most situations except when the database uses a schema other than DBO. In this case, the logins that map to database users with the default schema set to something other than DBO will not exist during replay. SA and Local Admin always maps to DBO by default. If…

    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 18 2008 6:52AM=-=>

    Hi Joe
    Rebecca will work with you on this one.

    <=-=Apr 29 2010 1:55AM=-=>

    Hi Joe,

    We will evaluate this in the next major release of SQL Server as we think about the next generation of DUTT.

    Shirley Wang
    Microsoft SQL Server Program Manager

  7. ReportServer and Report Manager do not work well with Vista and UAC unless UAC is disabled

    In Windows Vista, when trying to access the Report Manager web application in order to manage report catalog content, or when trying to deploy to a Report Server using BIDS, the UAC prevents local administrators from accessing Content Manager objects and features. It renders the report server pretty much useless unless UAC is disabled.

    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

    <=-=Jan 8 2008 2:34PM=-=>

    Thank you for filing this issue. Using Reporting Service in conjunction with UAC is somewhat difficult the first time you try it. Once you configure the roles correctly and add the report server URLs to Trusted Sites in IE, it work significantly better. Please review the following support article for comprehensive steps:
    http://support.microsoft.com/kb/934164/en-us

    We will consider this as we plan the remainder of SQL Server 2008.

    <=-=May 6 2008 9:48AM=-=>

    Thank you for filing this issue. Though it is tricky the very first time a user uses SSRS on Vista/Windows Server 2008, the scope of the change required to address the issue is too large for us to make a change as part of the SQL Server 2008 release. We will consider it for a future release.

    Thanks,
    -Lukasz

  8. Syntax BOL regarding Multi Insert is wrong

    In BOL the example for Multi Insert (B under Insert) is wrong.
    It is now:
    USE AdventureWorks;
    GO
    INSERT INTO Production.UnitMeasure
    VALUES ((N'F2', N'Square Feet', GETDATE()),(N'Y2', N'Square Yards', GETDATE()));
    GO

    It should be:
    USE AdventureWorks;
    GO
    INSERT INTO Production.UnitMeasure
    VALUES (N'F2', N'Square Feet', GETDATE()),(N'Y2', N'Square Yards', GETDATE()); -- Deleted ( and )
    GO

    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. SSRS 2008 Strange behaviour of charts with a Report Server Model as datasource

    I made a few tests on the November CTP, especially with the Report Server Model as datasource in the Report Designer Preview.

    I use the Adventure Works Samples for SQL 2008 found on Codeplex and did quite simple tests : a table displaying the sales grouped by year and by product category, and the histogram chart that corresponds.

    I have found strange things with the charts : sometimes the values they display are not the good ones. They are all equal to 1, even if the table still displays the good values.

    To compare, I made the same thing with…

    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 7 2008 8:02PM=-=>

    Thank you for the feedback.

    In CTP November, the RDL metadata tags created by the report designer preview for model-based queries are incorrect in this case. It detects System.String, when it should have detected System.Int32:

    Total Order Quantity System.String

    If you change this in the RDL manually, the drag and drop behavior will change and the default aggregate generated for chart data points will use =Sum(…), instead of =Count(…).

    That’s why you get the output you are seeing right now. Alternatively, you can also manually modify the generated aggregate function for the chart data point in report designer.

    Consequently, when you drag and drop that field into the chart data field, the designer generates a =Count(…) aggregate. However, if the metadata tags were correct, it would generate =Sum(…) and the chart would work as expected at runtime.

  10. Custom Data Processing Extensions Don't Show in the Standalone Report Designer

    Custom Data Processing Extensions don't show up in the Standalone Report Designer.

    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 31 2008 7:28AM=-=>

    Thank you for using SQL Server Reporting Services. We are investigating how best to partner extensibility features with the Stand alone desiger. The timeline for that is currently not set. Thank you for your patience.

    <=-=Jul 7 2008 12:09PM=-=>

    Custom data processing extensions will not be supported by Report Builder 2.0 (updated name for standalone report designer) when processing in local mode (not using a server resource). We are considering adding support for processing on the server to get capabilities such as custom data processing extensions. If this would solve your use case, we would love to hear feedback. Thanks.

  11. Non-Yielding Scheduler, Minidump, and

    During a fairly high workload, received errors indicating non-yielding scheduler and three worker thread "Worker 0x1EFEA0E8 appears to be non-yielding on Scheduler 3" messages in the SQL event log.

    Also received, in the Windows Event Log (Application):
    App: E 'Wed Nov 14 22:38:02 2007': Application Hang - " Hanging application tdpsql.exe, version 5.2.1.4,
    hang module hungapp, version 0.0.0.0, hang address 0x00000000. "

    Initial analysis of minidump indicates that the worker thread was doing some sort of nested loop join and at time of crash was in "sqlservr!LatchBase::ReleaseInternal", which was called by XVB::GetRecord. Minidump and dump logs are attached to this…

    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 4 2008 1:22PM=-=>

    Thanks for identifying the issue. We will look into it and get back to you with the resolution.

    <=-=Mar 17 2009 6:53PM=-=>

    this issue has been identified and fixed. The fix is available in YUKON/SP2 and YUKON/SP3 CUs. Please go for the latest CUs. For questions, please feel free to contact us

    thanks
    Sunil

  12. BEGIN STACK DUMP - Non-yielding Scheduler

    This is an addition to Bug ID 279369. We are getting the same error in Sql Server 2005 SP2 version too.
    The dump files are attached.

    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 17 2007 2:01PM=-=>

    Dear Customer,
    Thanks you very much for taking the time to send us feedback. We have looked at and understood the bug and are working on a fix. We will keep you updated on the progress.
    Best regards.

    <=-=Dec 13 2010 9:36AM=-=>

    Dear Customer,

    Please forgive the rather long wait for a followup, this fell between the cracks. The issue reported was fixed in SQL 2005 build 09.00.3200.00 which shipped in 2008. Any recent Service Pack or Cumulative Update thereof has the fix.

    Campbell, SQL Development

  13. MSFT - Maddog: Exec MachineRequestSelect is slower in Katmai

    One of the three most used Maddog sprocs that is slower in Katmai when compared to Yukon.

    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 17 2007 3:01PM=-=>

    Josh,
    The defect is currently under investigation. We will keep you updated on the progress.
    Thanks and best regards.

    <=-=Jan 22 2008 11:33AM=-=>

    Josh,
    We found out that this bug is a duplicate of “MSFT – Maddog: Exec MachineRequestSelect is slower in Katmai” (307401), which is still under investigation.
    Best Regards,
    Roman

    <=-=Jan 22 2008 1:22PM=-=>

    You just duped this bug to itself. Is there a different bug you’re referring to? Or should this bug still be active?

  14. MSFT - Maddog: exec dbo.ResultInitialize is slower in Katmai

    One of the three most used Maddog sprocs that is slower in Katmai when compared to Yukon.

    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 17 2007 3:00PM=-=>

    Josh,
    The defect is currently under investigation. We will keep you updated on the progress.
    Thanks and best regards.

    <=-=Jan 10 2008 9:41PM=-=>

    Hi Josh, we are still investigating this issue. Right now, we are looking at cernrates in the storage engine to determine the potential root cause of the slowdown.

    Thanks,
    Torsten Grabs
    SQL Server Program Management

    <=-=Feb 19 2014 5:59PM=-=>

    We are closing this defect as ’won’t fix’. Please feel free to re-open it if it continues to be an issue

    thanks
    Sunil

  15. SSRS: Can't use publisher policy for custom report assembly

    Apparently a publisher policy does not work for custom report assemblies both in Business Intelligence Studio and ReportService.

    When I debug (devenv on devenv) and break at the FileNotFoundException I see a ReflectionOnlyLoad on the stack

    mscorlib.dll!System.Reflection.Assembly.ReflectionOnlyLoad(string assemblyString) + 0x1a bytes

    Microsoft.ReportingServices.Diagnostics.dll!Microsoft.ReportingServices.Diagnostics.AssemblyLocationResolver.LoadAssemblyAndResolveLocation(string name = "xxxxxxxxxxxxxxxx, Version=1.0.0.0, Culture=neutral, PublicKeyToken=01234") + 0x3d bytes

    This prohibits a vendor model for custom report assemblies, where functions are added to the assembly from one version to another.

    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

    <=-=Nov 2 2007 6:29PM=-=>

    Thank you for your feedback.

    Could you please explain in more detail of how exactly you apply “a publisher policy”?

    Note that assembly redirection can be accomplished through app config files. In the RS web service case, you should try adding it to the web.config file. For the RS windows service, you should add it to ReportingServicesService.exe.config.

    <=-=Nov 4 2007 2:01PM=-=>

    The assembly and the publisher policy are installed using Microsoft Installer.
    Modifying the Report Server’s web and application configuration files during installation is hardly feasible. It would require an incredibly smart custom action that finds the correct SQL server instance or installation of Visual Studio, makes the appropriate changes to their configuration files, and is able to repair and maintain the changes even if SQL Server or Visual Studio are re-installed.
    This means I would need to put much more development effort into…

  16. SSAS Data Mining Prediction Join: "Memory error: Allocation failure"

    We've recently run into an issue and are in lack of a work-around when executing a prediction join against a decision tree model. Specific information is below, but it is interesting that we were able to build/process the mining model without errors but are consistently (and immediately) getting the error "Memory error: Allocation failure" when executing a prediction join against the model.

    SQL Server Build:


    • The server provided is 64-bit and is running for analysis is running the 64-bit build of SQL Server 2005 build 9.0.3042.


    • The server has 8 GB of RAM


    Model Information:



    • Decision Tree with the followng…

    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 9 2008 8:25AM=-=>

    Thanks for submitting this issue. We looked at this for 2005 SP3, but it was not accepted. We have assigned the bug for a fix in our next major release.

    There will always be a limit on the complexity of the queries we can run, and it looks like you have discovered it. Your ask is to increase those limits, or to revise functionality that unnecessarily constrained those limits. For service packs and hot fixes, it can be hard to make a case for an incremental change in scale, because there is always another limit exposed by the first fix. However, if this continues to block progress, you should go to CSS with your portable repro, and file an RFC.

    Thanks,

    jkh

  17. MSFT-MSO: Double-click not working on "Pick job schedule page"

    The standard windows behaviour of double-clicking on a grid item and be able to select the item is not working on "Pick Job Schedule 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 →

    Upvotes: 1

    <=-=Oct 29 2007 10:13AM=-=>

    niyer,

    Thanks for the feedback. I’ll see if we can get this addressed.

    -Richard Waymire
    Program Manager, SQL Server Agent

    <=-=May 14 2009 11:22AM=-=>

    Thanks for the input. We are considering fixing this for the next release.

    Thanks,

    Gil

  18. Exception raised when trying to open "Data transformation service" node in Microsoft SQL Server Managment Studio

    First - error message appears
    Click second time - .Net Framework exception raised.

    Please see attached movie for 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: 0

    <=-=Feb 28 2008 7:43AM=-=>

    Back in October, you wrote, telling us about problems opening up the Data Transformation Service node in management studio. I am happy to inform you that this issue has been fixed. You can see the improved functionality in our February CTP release, now avaiilable for download.

    Thanks for the help!

    jkh

  19. MSFT: Maddog - Results to text col limit too short

    Results to text limits column lengths to 8k. This is a problem because often to try to evaluate query issues, you want to use statistics xml and show_plan and send the results of those queries to collegues. Since the default grid based results aren't very helpful, you just want a flat file, you turn to 'results to text', which then truncates the results of the queries because of the 8k limit.

    It would be acceptable to have this only enabled in 'results to file' mode, but since that currently runs under the same assumptions as 'results to text', that isn't…

    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. Wrong partition limatition

    Wrong partition limatition is situated when in query used parameter and operator OR.

    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

    <=-=Dec 27 2007 12:18PM=-=>

    Thanks for reporting your problem with partition elimination. Unfortunately, SQL Server 2008 currently does not support implied partition elimination for queries containing disjunctive, parameterized range predicates.

    We are currently prioritizing our list of design change requests and may address this issue in one of the subsequent relaeses.

    Regards,

    Joachim Hammer

    Program Manager
    SQL Server

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base