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

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

  5. Hyperlink in subscription email has bad characters

    For specific subscriptions, text in the subscription hyperlink is overwritten by "! " which breaks the link. This issue is now holding up rollout of Reporting Services to production.

    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

    <=-=Mar 7 2006 6:12PM=-=>

    There is no attachment to this issue. Can you please attach RDL file and example of output?

    <=-=Mar 8 2006 9:06AM=-=>

    I have added an attachment with the rdl as requested. I have also added the stored parameters from the database and how they are rendered in the url in the email by the email delivery extension where the bug occurs.

    <=-=Mar 20 2006 11:36AM=-=>

    I have applied the CTP SP1 – however, Reporting Services 9.00.2040.00 still generates subscription emails with breaks in the hyperlink.

    <=-=Mar 28 2006 2:36PM=-=>

    This seems like a coruption after RS sends the email. Can you please have RS drop the email to the local file system and see if the file is corrupt.

    To do this in the RSReportServer.config file set SendUsing to 1 and set the SmtpPickupDirectory to a local directory. If the file is not corrupt…

  6. Severe performance degradation accessing AS2K cubes with ANONYMOUS USER and Yukon OLAP provider

    When our product, ProClarity 6.1, accesses AS2K cubes using ANONYMOUS USER access and the Yukon OLAP provider, creating a connection takes approximately 15 minutes. If I use the AS2K OLAP provider instead, connection takes less than 5 seconds. During the establishment of the connection, our product identifies a collection of unique member names that it can use as query scoped members in an MDX query. To do this we construct a potention member unique name. We then perform a MDSCHEMA_MEMBERS lookup with a restriction set to our potential name. The purpose of the lookup is to confirm that the member…

    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

    <=-=Jan 27 2006 4:44PM=-=>

    Please try including “ConnectTo=8.0” in the connection string, and let us know if it fixes the problem?
    Thank you

    <=-=Feb 10 2006 4:58PM=-=>

    I tried setting ConnectTo=8.0 The setting had no effect. A connection still required 15 plus minutes.

    <=-=Apr 24 2006 2:36PM=-=>

    “Dear gbraach, We have been unable to repro this issue. Could you please provide additional information or repro steps?”

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

    I reproduced this problem using SQL2K5 SP1

    <=-=May 18 2006 5:24PM=-=>

    Thank you for reporting this issue. Our investigation shows that there is no difference in the schema retrieval time (Proclarity connection) between Yukon provider and Shiloh provider connecting to AS 2000. This means, we are not able to repro the following: “If I use the AS2K OLAP provider instead, connection takes less than 5 seconds”. The reason of the performance degradation might be in the way Proclarity…

  7. uneven column count import using SSIS

    Microsoft SSIS could you please read the entire thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=212013&SiteID=1&PageID=0
    and please give a reasonable answer to users of SSIS and when you believe a solution to this issue will be released. SSIS is a great package however this bug is causing a great deal of inconvenience. Thanks again for the support.

    Please check forum here for growing concern over this issue. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=212013&SiteID=1&PageID=0

    how can you import a straight CSV file with and uneven column count.

    For example:(assume CR LF row delimiter)

    The,Quick,Brown,Fox,Jumps
    Hello,World
    This,is,a,test

    "Normally" I'd expect this
    | Col1 | | Col2 | | Col3 | |…

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

    <=-=Apr 12 2006 1:00PM=-=>

    Unfortunately, there is no a setting, like you expected, to direct the parsing of flat files to first break rows and then columns.

    The flat file parsing for SSSIS in SQL Server 2005 works on column by column basis, for performance reasons.

    That is something we already had users ask for after the release, and it should definitely be available in the next version of the product. In the meantime people usually use the script component to do this type of parsing � there are a few good posts about it on the SSIS MSDN forum.

    Thanks.

    <=-=Dec 8 2006 12:14PM=-=>

    Unfortunately, as I said before, there is no a switch to allow this functionality at this time.

    The workaround is to use the RaggedRight format to parse the fixed set of columns and then split the last column either using the Derived Column…

  8. Can't open DTS 2000 Packages

    Can�t open the DTS 2000 Packages

    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 27 2005 4:21PM=-=>

    Hi Sergio, unfortunately, without more information, we cannot reproduce this problem. Where are you clicking on the DTS 2000 packages? On the Management Studio? Is this an upgraded server? Please give us as much information as possible about the problem so that we can troubleshoot it. Thank you!

  9. MDX - NON EMPTY clause combined with Crossjoin() function removing calculated members from axis when they actually resolve to a n

    When the non-empty clause is added to an axis that has a dimension (other than the measures dimension) that has calculated members and is crossjoined with another dimension, the calculated members are excluded from the result set.

    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. Rubbish error message when I try and run a package that isn't checked out

    If you try and run a package that is checked into sourcesafe then you get a rubbish, completely non-descript, error message that doesn't mean anything. You can see it in the attached screenshot.

    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 21 2006 3:16PM=-=>

    We are not able to reproduce this error. Could you provide any information that might affect the scenario so we can repro this?

    <=-=Mar 21 2006 5:32PM=-=>

    We are not able to reproduce this error. Could you provide any information that might affect the scenario so we can repro this?

    <=-=Jun 16 2006 4:32AM=-=>

    Yeah, this was when using Visual SourceSafe (v6.0 I think) as our source control system. How did you try and reproduce it? For me it was simply a case of right-clicking on a checked-in package and selecting ‘Execute’.

    The project has since migrated to using Team Foundation Server but I’m not sure if the problem occurs there or not. I’ve left the project now so can’t check!

    Also, Microsoft Connect doesn’t show the attachment so I can’t see what teh original error message was.

  11. DTS Package Gets Corrupted

    When SQL Server 2000 DTS package with FTP task saved in EM on machine having SQL Server 2005 client tools installed, it cannot be opened on a machine without SQL Server 2005.

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

    Hello, thank you for using SQL 2005
    Are you using SQl 2000 sp3? The issue sounds similar to some corrected with SQL 2000 sp4

    <=-=Jan 31 2006 1:56PM=-=>

    Hello, thank you for using SQL 2005
    Are you using SQl 2000 sp3? The issue sounds similar to some corrected with SQL 2000 sp4

  12. Add new stored procedure breaks object explorer

    Created a new query but it did not show in the ojbect explorer even aafter refreshing.
    I finally closed Management Studio and now I cannot open object explorer - fatal error parsing xml (see attached). I know sproc is there, I can see it via 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: 1

    <=-=May 19 2005 9:24AM=-=>

    Hi Julie,
    Thank you for your bug report regarding adding stored procedure. I have several questions:
    1. Can you attach the error report that you got?
    2. When you say in step 1 of the report, Create a new query, did you do a CREATE PROCEDURE statement inside of the Query Editor, or did you start from the “New Stored Procedure” command of the Stored Procedure node in Object Explorer
    3. Did you actually Execute the query to save the stored procedure, or did you just Save the query file.
    Thank you,
    Bill Ramos

    <=-=May 24 2005 2:24PM=-=>

    Hi Julie,
    We still haven’t been able to reproduce this problem. If you could be more specific about the commands you executed and the types of objects you tryied to create, we could try to preproduce this later. For example, there was some confusiong over what…

  13. Install Path display disappears when changing install options

    After clicking "Advanced Options" under the SQL 2005 install, and then changing the options to include all DTS runtime and no Books online, the Install path display disappears (no longer showing what directory it will be installed to), in addition the button that allows me to change this path also becomes inactive.

    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. SSIS Expression Language fails to evaluate a DATE function after installing SQL 2005 SP1

    I have a Data Flow which includes a Derived Column task. The task uses an expression to check a date value for the year 2079. It uses the YEAR() date function within the the CONDITIONAL operator. The package fails to evaluate the date function. Here is the error I am trapping:

    An error occurred while evaluating the function.

    The "component "Update Max Date Value to NULL" (346)" failed because error code 0xC0049067 occurred, and the error row disposition on "input column "WeekEndingDate" (455)" specifies failure on error. An error occurred on the specified object of the specified component.

    The ProcessInput…

    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

    <=-=May 5 2006 11:24AM=-=>

    I am unable to reproduce this. Could you perhaps hook up the error output of the derived column and redirect error rows, and then see what value(s) of LastWorkedDate it’s failing on?
    Thanks!

    <=-=May 22 2006 4:20PM=-=>

    Hello
    We tried but couldn’t repro this with the existing info. Pls reactivate if it still reproduces for you and let us know some more details then (pls refer to Microsoft Comments above). Thanks!

  15. Problem with sys.sql_modules catalog view.

    When you access this view to look at the definition of an object that is greater than 8000 characters, it appears to only return the 8000 characters stored in the row itself. The field is listed as nvarchar(max).

    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

    <=-=Dec 9 2005 7:03AM=-=>

    I have determined that the problem dealt with a limitation of the SQL Query Editor. The editor will only display a maximum of 8192 characters in text mode. I used BCP to get my object script out of the database in its entirety.

    <=-=Jan 10 2006 12:28PM=-=>

    We do have the limitation of 8k for text results, and 64k for grid results. But the users can work around this by editing the trigger from the context menu and the trigger text will get displayed in a query window.

    <=-=Oct 15 2007 1:32PM=-=>

    There are duplicates on the same issue and we will track and address it with Connect ID 126437.

    Thanks,
    -Eric

  16. SQL Server 2005 JDBC Driver Beta 2 - executeBatch() does not work on PreparedStatement / Statement

    calling executeBatch() respective executeBatch(String sql) does not work on a PreparedStatement / Statement. There is no exception but no records will be stored in the database.
    The code worked with the previous JDBC driver of SQL Server 2000 on a SQL Server 2000 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 →

    Upvotes: 1

    <=-=Dec 1 2005 11:56AM=-=>

    I cant repro this bug with the b2 drop or the latest drops. Can you provide more info?

    <=-=Dec 7 2005 11:56AM=-=>

    I cant repro this bug with the b2 drop or the latest drops. Can you provide more info? you email me directly to microsoft.com email alias mugunm

  17. Surface Area Config dialog (and sub dialogs) text exceeds window space

    The text in both the SQL Server 2005 Surface Area Configuration dialog, and sub dialogs such as the Features, runs past its allotted space. In the case of the main dialog, the line after the three bullets cuts off just above center and is unreadable (no scroll bars, non-selectable text). In the case of the Features dialog, only the "Dedicated Administrator" description text runs off the right side of the window (the other descriptions wrap correctly). In the case of the Services and Connections dialog, the last word (linked "Configuration") is wrapped and cut in half (only the top half…

    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. moving msdb prohibits WMI alerts from being created

    Cannot create WMI alerts after moving msdb.

    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

    <=-=Apr 17 2006 3:08PM=-=>

    Hi Micahfox ,

    In general, sp_detach_db and sp_attach_db is NOT recommended way to move a system database.

    Our test team validated this scenario by using the recommended way to move database (see topic �Moving Database Files� in BOL) and it works fine.

    There was no problem with sp_add_alert once msdb was moved.

    The steps followed 1. determine the logical name of the database and current location of physical files

    SELECT name AS [logical name], physical_name AS [location]

    FROM sys.master_files

    WHERE database_id = DB_ID(‘msdb’)

    2. change the location of each file from the step 1

    ALTER DATABASE msdb

    MODIFY FILE (NAME = , FILENAME = )

    USE master;

    GO

    ALTER DATABASE msdb

    MODIFY FILE (NAME = MSDBData, FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\msdbdata.mdf’);

    GO

    ALTER DATABASE msdb

    MODIFY FILE (NAME = MSDBLog, FILENAME = ‘C:\Program…

  19. 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 →
  20. 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 →
  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base