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 DB connection maintained even when OLAP database using it is deleted.

    SSAS seems to be keeping the connection to the SQL Server database referenced in a data source around (in a connection pool, perhaps), even though the OLAP database that used it has been deleted. Then, if a new SQL database and OLAP database are created with the same name on the same server and the cubes are processed, SSAS is attempting to reuse that old connection. Since the connection was killed, it gets the error:

    Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: A transport-level error has occurred when sending…

    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. performance drop over 20x if using ado.net compared with sql management studio

    I have 2 apps doing the same job, one is older and using adodb to query sql
    server 2005, another is using ado.net. Something has happened and now app
    using ado.net execution time of some stored procedures has increased about
    ~20 times from <1s to 20s in comparison with older app or SQL
    Management Studio. I've found that commenting/uncommenting out a simple ORDER BY PaymentDate, changes execution time back to normal/slow. This sp queries data from 2 tables, in one table PaymentDate cannot be null, in the other it can, the problem is
    then it must get data…

    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

    <=-=Mar 23 2007 2:50PM=-=>

    Gercas,

    I am unable to reproduce this in my environment. Do you have data that I can use to reproduce this? I attempted to set this up but am unable to set up the entire thing without your schema and data.

    Thanks,

    Carl Perry
    Program Manager ADO.NET
    Microsoft

    <=-=Sep 21 2010 1:14AM=-=>

    Hi,

    We had the same problem, try to add an ‘with recompile’ inside the stored procedure that i called by the application using the ADO.NET, it worked for us.

    Victor

  3. Cannot reference variables with same name but diffirent namespaces in script component

    It is impossible to reference 2 variables that have the same name but a different namespace in the script component. The variables collection doesn't differentiate between them.

    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

    <=-=May 10 2007 10:56AM=-=>

    Thank for using SQL Server Integration Services.
    Apologies for the delay. We are working on the general scripting environment and should address this issue in a future release.

    <=-=May 10 2007 11:20AM=-=>

    Does “future release” mean katmai or katmai+

    ??

    <=-=Feb 11 2008 6:40AM=-=>

    Apologies for the delay.
    The scope is for Katmai, SQL 2008.

    <=-=Oct 14 2009 11:00PM=-=>

    Pardon?
    Katmai SHIPPED well over a year ago and it didn’t get addressed. So, what is the timeline now?

  4. Package failing when moving over Custom data types because rule does not exist

    An SSIS package I've written is failing because when the Transfer SQL Server Object Task runs it is trying to bind a data type to a rule, but the rule does not yet exist. I have IncludeDependentObjects enabled.

    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 14 2006 9:28AM=-=>

    Hello,

    thank you for reproting this problem. We are investigating the issue and work on a resolution.

    Regards,
    Ovidiu Burlacu

    <=-=Jan 30 2007 3:31PM=-=>

    Thank you, we are unable to repro the problem while using SQL 2005 SP1 or the soon to come SP2. It seems you were testing with the original SQL 2005. I apoligize for the delay and perhaps you have now instlaled SP1 and no longer see the issue? We are going to resolve and close this as not reproducable but you can certainly re-open if you reproduce the issue in SP1 or SP2. Thank you.

  5. clicking on stored procedures in object explorer makes management studio hang

    When you click on the stored procedures folder in the object explorer management studio hangs.

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

    Hi Gerald,
    Thank you for submitting feedback regarding the behavior you are experiancing. I was not able to reproduce this problem and it’s a very common scenario. Can you describe a little more about your client system and the server you are connecting to? Do you happen to have the Summary page up and running? Can you run a profiler trace to see what T-SQL was sent to the server when you experianced the hang. What other software was running on your system at the time that could have been consuming resources.
    Thank you,
    Bill Ramos

    <=-=Jul 20 2006 8:10AM=-=>

    Hi Gerald,
    We have not been able to reproduce this problem against any internal or released version of SQL Server 2005. We are resolving this bug rerport. If you can provide more details around the problem, please reactivate the bug with more information…

  6. Unable to connect to Reporting Services from Management Console

    Cannot connect to <SERVERNAME> (name provided by error message)

    Additional information:

    Client found response content type of &#39;text/html; charset=utf-8&#39;, but expected &#39;text/xml&#39;.
    
    The request failed with the error message:

    . . .

    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 19 2006 1:43PM=-=>

    You need to access your report server virtual directory in a browser, preferrably locally. This will tell you what the actual error is. Usually they are pretty descriptive as to what needs to be done to fix them.

    <=-=Aug 7 2006 5:30PM=-=>

    Usually this can be solved by using a browser to navigate to the Report Server virtual directory. The error page should give you and idea of the problem.

    If you see an ASP.Net 1.1 error and you’re actually running SQL Server 2005, try using the aspnet_regiis.exe -iru command to register ASP.NET 2.0 script maps on the reporting services virutal directories. You can also try using the Apply Default Settings checkbox on the virtual directory pages in the reporting services configuration manager.

  7. Reporting Services Row Height Error on Export To Excel

    A report was created using VS.NET 2k5 with 2 sections to the report. The 1st section comprises of a rectangle, with 4 tables, one at each corner of the rectangle. The 2nd section uses a grouped list with embedded table. The problem is occuring in the 1st section.

    The tables in section one duplicate each other in that all they display is a parent name for a collection of stats (in the header), the collection of stats that are children to that parent (in a group), a description of the stat and a traffic light to signify it's performance (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: 0

    <=-=Jul 18 2006 4:32PM=-=>

    We can’t reproduce the problem here. Can you please attach the RDL and the .rdl.data file?

    <=-=Jul 20 2006 1:41AM=-=>

    All attached. Take the most recent rdl.data as i’m not sure the first one uploaded correctly (I was using Firefox).

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

    The status on this now says that the resolution is “Other”. Can you provide more details as to whether this has been fixed or not?

    Thanks.

    <=-=Nov 3 2007 11:26PM=-=>

    Unfortunately, it didn’t look like the report definition ever got attached to this bug. Could you try out with the SQL Server 2008 July CTP? The Excel rendering extension has had some extensive changes.

    <=-=Dec 2 2009 8:27AM=-=>

    I just came across the same issue and was lucky enough to have a co-worker who had seen this issue so I thought I’d post the solution. Excel can’t seem to…

  8. The job failed. The owner of job does not have server access.

    We are using 2005, clean install on new server running Windows Server 2003 R2 Standard. We have an active directory group, SQLDBA, with our DBA domain logins. This group is a user in the DBMS. The scheduled jobs run under SQLAdmin, which is a service account we set up when we installed SQL Server 2005.

    Using windows authentication, I log on to the server and to SQL Server. Months ago, I created several maintenance plans with the Maintenance Plan Wizard that are scheduled to run nightly. My domain login is the owner, which is a member of the SQLDBA group.…

    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

    <=-=Jul 12 2006 12:22PM=-=>

    I just reproduced the problem on a third server, configured the same, but I applied SP1. The service pack does not address this error.

    <=-=Jul 21 2006 3:00AM=-=>

    Hi,
    I experience exactly the same problem with an SQL2000 SP4 installation on a Windows Server 2003
    Jobs are schedule under a domain account.
    After each computer reboot all jobs fail with exactly the same error message.
    Changing job owner to sa and then back to the domain account let the jobs run again until next reboot.

    <=-=Aug 11 2006 1:28AM=-=>

    We could not repro it in our labs with the below repro steps.
    1. SQL Agent service account is running as NT Non-Admin on the box(Treid with NT Admin as well)
    2. Created group DBA on machine M1 and added account x to this group
    3. This group is granted sysadmin privilege on SQL Server.…

  9. generate script to create database, running script has errors

    User description contained Unicode characters - description text was copied to a Notepad file and attached to the feedback in the Microsoft database.

    NEW September 26, 2006 - uploaded step-by-step screen captures

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

    <=-=Sep 26 2006 6:34AM=-=>

    Hi JohnPaulCook,

    Thank you for your feedback. Please let us know the repro steps in little more detail and we shall look into the problem.

    Thanks

    <=-=Sep 27 2006 2:14PM=-=>

    Thank you for taking the time to report your issue with the scripting component of SQL Server 2005 Management Studio. The issue does not occur in a recent build of SQL Server 2005 SP-2 that is currently in the beta testing phase.

    Best Regards,

    Keith Wilson
    SQL Server Tools Test Team

  10. XML/A script bug cause duplicated ID in the metadata

    Using an XML/A Script command I can generate a duplicated ID (specially a permissionID) which corrupt the database metadata.
    After I can create this duplicated ID, I can't no longer edit my cube, dimension or security component because there is a duplicated ID, so the server cannot deserialize the metadata.

    > TITLE: Microsoft SQL Server Management Studio
    > ------------------------------
    >
    > Property accessor 'Description' on object
    > 'Microsoft.AnalysisServices.Dimension' threw the following
    > exception:'Deserialization failed: Another 'DimensionPermission' object
    > has the 'DimensionPermission' ID.' (System)
    > ------------------------------
    > ADDITIONAL INFORMATION:
    >
    > Deserialization failed: Another 'DimensionPermission' object has the
    > 'DimensionPermission' ID.…

    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. IE 7 Beta 3 hangs when opening SQL Server Reporting Services Report

    After deploying a blank report to Reporting Services and opening it with IE 7 Beta 3, IE hangs and sometime peaks up to 100 Percent processor time. The symbol in the tab flicker and IE is unresponsive. This problem can easily be reproduced by building a simple and empty (I tried that with one textbox)

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

    <=-=Jul 26 2006 6:08AM=-=>

    There is another problem. When I tell it to temporarily allow popups, and go back to do whatever I need, it still blocks the popup, expecially if it is an important popup.

    Thanks.

    <=-=Aug 4 2006 6:19PM=-=>

    Why am i receiving a run time error when i try to access my portfolio. using MSN Money?It does not happen going through MSN Explorer.

    <=-=Sep 28 2006 8:47AM=-=>

    This was a known issue that has since been fixed by the IE team. The release candidate for IE7 no longer exhibits this behavior.

    <=-=Aug 14 2009 11:41AM=-=>

    Thank you for yoru feedback. This issue that you have reported has been fixed in the latest build of SQL Server 2008 R2 (in CTP3) and Visual Studio 2010 (in Beta2).

    Thank you.

    Stella Chan
    SQL Server Reporting Services

  12. Stored procedures with goto Label having "ANSI_WARNINGS OFF" fail.

    Stored procedures with goto Label having "ANSI_WARNINGS OFF" fail.
    It returns

    message 102, Level 15, State1,
    not collect

    With
    "ANSI_WARNINGS ON"
    or not specified success.
    Try following step...

    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 6 2006 6:09PM=-=>

    This feedback picked from ms-newsgroup in japan
    http://www.microsoft.com/japan/communities/newsgroups/browser/default.mspx?dg=microsoft.public.jp.sqlserver.server&lang=ja&cr=JP&r=4a3069c3-5de9-4939-9101-77c412bd2740

    <=-=Oct 9 2006 1:05PM=-=>

    Hi,

    Thank you for raising this issue. This issue should be fixed in SQL Server 2005 SP2.

    Regards,
    Tomer Verona
    SQL Engine Development

  13. Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the so

    I got the exception below when opening a table.
    I Closed the table, and try to re-open it, it opened normally.

    Table contains two constraint key, and about 35 column and 1489 data rows.


    System.ArgumentException: Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection.
    at System.Buffer.BlockCopy(Array src, Int32 srcOffset, Array dst, Int32 dstOffset, Int32 count)
    at Microsoft.VisualStudio.DataTools.UI.QueryResult.FileStreamReader.ReadOneT
    at Microsoft.VisualStudio.DataTools.UI.QueryResult.FileStreamReader.ReadInt32(Int64 i64Offset, Boolean bSkipValue, SpecialDataType& specialDataType, Int32& val)
    at Microsoft.VisualStudio.DataTools.UI.QueryResult.DiskStorageView.SequentialReadColumn(Int32 iCol, Boolean bSkipValue)
    at Microsoft.VisualStudio.DataTools.UI.QueryResult.DiskStorageView.GetCellDataFromFileInternal(Int64 i64Row, Int32 iCol, Boolean fGetRealData)
    at Microsoft.VisualStudio.DataTools.UI.QueryResult.DiskStorageView.GetCellData(Int64…

    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 12 2006 9:49AM=-=>

    Thank you for your bug report regarding Open Table. Are you able to consistently reproduce the problem?
    Thank you,
    Bill Ramos

    <=-=Jul 18 2006 2:18PM=-=>

    Hi FarSee,
    In looking into this problem, we have determined that the issue doesn’t warrant a fix for SP2. We are going to look at this in the next major release of SQL Server.
    Thank you,
    Bill Ramos

  14. SQL Server Agent properties in Management Studio shows wrong server adresse

    When I, in my Management Studio, open properties for the SQL Server Agent it shows wrong title on the form. It looks like it replaces . with (Local), this makes the title looks strange when connected to a server with a IP adresse.

    In my case:
    143(Local)97(Local)3(Local)180

    The SQL Server agent is running on SQL Server 2000 but the Management Studio is 2005, so I guess this is the correct place.

    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. German errormessage / "No mapping between account names and security IDs was done"


    1. Bug:

    Win 2003 Advanced Server, english
    SQL 2005 Enterprise Edition, english
    SQL 2005 SP1, english

    Regional Settings: german

    The error: "Systemfehler: ." occurs, no more details

    After switching the regional settings to english, the error below occurs.


    1. Wish

    More detailed error message, the stated error message means: check you users in the rolesdefinition.

    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. SQL Management Studio Express errors on Vista

    When working with SSMS-E on Vista (build 5456.5), an error occurs when enumerating databases, tables, etc. The error happens once, and then if you refresh the node, it won't happen again.

    Note: this is on vista even though the OS for this report says WinXP -- Connect would not allow me to keep the selection as Other.

    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. can't save Profiler trace to file

    can't save Profiler trace to file , this option not available
    Logged as admin -> create new trace -> check save to file
    as soon as cursor moved from checkbox area it become unchecked

    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 3 2006 4:53PM=-=>

    Thanks for sending the wmv over. We reviewed it last week. We are still unable to reproduce the behavior in our labs. Could you try the following…

    1) Open Profiler
    2) Start new trace without saving to file
    3) After the trace has collected some events, stop the trace.
    4) Choose File → Save As → Trace File…

    If this works, you have a workaround. (You can also save to a file by setting up a trace through T-SQL)
    If this doesn’t work, I do not think the problem you are experiencing is due to SQL Server’s tools. Your machine most-likely has an improper configuration that could have been caused by failed installations or using beta software. Some of your system files may be the problem.

    Please let me know your findings at your earliest convenience.

    Paul A. Mestemaker II
    Program Manager…

  18. Unable to edit values by typing in cells when joining tables opened via Object Explorer

    When opening a table using Object Explorer and joining that tble to a second table using an Inner Join on the primary key of each table, I am unable to edit the data by typing new text (or numbers) in any of the cells displayed (in Sql Server Management Studio and similarly in Visual Studio 2005). In contrast, if I run the same query in Visual Studio 2003 on the same tables, I am able to edit the data in either table. If I only query one of the tables in SSMS (or in Visual Studio 2005) then I am…

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

    <=-=Jun 27 2006 10:11AM=-=>

    Hi Matt,
    Thank you for taking the time to describe the problem with the query designer and its inability to edit data in joined tables. Did this used to work for you in SQL 2000?
    Thank you,
    Bill Ramos

    <=-=Jun 27 2006 11:37AM=-=>

    I see this problem when querying tables in either a Sql Server 2000 DB or a Sql Server 2005 DB. Please see the “Expected Results” portion of my initial bug-report for more info.

    <=-=Jul 10 2006 8:22AM=-=>

    Hi Matt,
    I did some digging around and it turns out that the team that supplied SSMS with the component disabled editing of the results set when multiple tables are involved. Your best bet is to create a view and then edit the data for the view. SQL Server will then be responsible for the possible updates. We will investigate what it will take…

  19. Database Backup and Restore Events report in SSMS returns no data

    The Database Backup and Restore Events report in SSMS returns no data for a database even though it has been backed up/restored. This is on Build 2153 (Post SP1 hotfix rollup). I've attached screenshot of empty report and csv of one of the report queries captured from Profiler that shows that data is being returned to the report, it's just not being displayed

    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

    <=-=Jun 30 2006 4:36PM=-=>

    What on earth does the Resolution “RESOURCE NOT LOCATED” mean?

    <=-=Jul 13 2006 9:06AM=-=> Hi Jasper,

    I am not sure what the resolution “RESOURCE NOT LOCATED” means, but I can confirm that this issue has been resolved and the fix will show up in SQL Server 2005 SP2 release.

    Thank you for submitting this defect.

    Regards,
    Maciek Sarnowicz

  20. DB-Owner cannot exec stored-proc that he himself created!

    I think that the following bug is backward-comatability issue with 2005 vs. 2000.

    The script below runs perfectly on SQL2000, but fails on SQL2005.
    Please note: I need to run it under an SQL-login, NOT a windows-login.
    I grant this SQL-user a db_creator server-role.

    Apart from that, I set my SQL-User to be ddladmin+dbwriter+dbreader on the 'model' db.
    (and of-course, remove the db_owner on 'model' - this is what makes the bug happen).
    The reason is I want this user to have those access-rights to any new DB that he does NOT own.
    For DBs that he does own, 'model'…

    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