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

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

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

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

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

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

  8. 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 →
  9. 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 →
  10. 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 →
  11. 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…

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

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

  14. 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 →
  15. SQL Server Management Studio: window close button doesn't work

    The close button on some child windows (the X widget on top-left window) sometimes doesn't work properly.
    The icon mouse, when moved on it surface, became as angular-resizer.

    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 23 2006 3:46PM=-=>

    Thank you for reporting the problems you are encountering trying to close a window in the sql server tools. I am sorry that you are having problems reproducing this behavior. I too am unable to cause this problem to occur.

    I am going to mark this issue to indicate that we don’t yet have a repro case. I encourage you to continue your efforts to isolate the conditions that lead to this problem. If you are able to do so, please return here and activate the issue, which will again bring it to my attention.

    Thank you,

    James Howey

    <=-=Sep 15 2006 4:36AM=-=>

    The bug appers sisthematically.

    <=-=Sep 15 2006 7:24AM=-=>

    We have been unable to reproduce this behavior in our labs. Regretably, we are unable to diagnose and fix a problem we cannot reproduce.
    If you should figure out what sequence of operations…

  16. Single Tran Insert into a remote SQL server becomes multipe inserts.

    I`m running a insert from a SQL 2005 server (SP1) to a SQL 2000 server (SP4 build 911). The insert enters 20 rows. However the insert is being broken down into 20 individual inserts which are causing triggers to fire 20 times where as we want them to fire once.

    If i run the same code from SQL 2000, the insert is only fired once.

    I have confirmed this by tracing and examining the execution plans.

    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 21 2006 5:02PM=-=>

    Hi,

    I have found an error in my testing and reproduced the behaviour with SQL 2000 to SQL 2000 so please close this case as i now need to research the behaviour further.

    Thanks

    Andrew

    <=-=Jul 18 2006 10:21AM=-=>

    I will try to find out the repro, but please please please include the create table commands – it helps us out a lot.

    Thanks,
    Conor Cunningham
    Microsoft

    <=-=Sep 27 2006 6:28PM=-=>

    Closing it. Thanks.

  17. Cannot reference objects by name in an XMLA Process command

    The XMLA Process command references objects by ID rather than name. I really don't think this is a good idea. ID is an immutable property so it doesn't make sense to use it to identify objects especially as we don't have much control over what value is in there..

    I've talked about this here: http://blogs.conchango.com/jamiethomson/archive/2006/06/20/4106.aspx

    I DO think this is a bug because I think this behaviour is a mistake.

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

    <=-=Aug 18 2006 4:40PM=-=>

    This is a good suggestion. We will consider it for the next release of SQL Server.

    <=-=Jul 26 2007 12:22PM=-=>

    According to an email that I have just received pertaining to this submission “Field Resolution changed from [Not Set] to [Won’t Fix]”

    Why is that? Why can’t it be fixed? How about an explanation? I do not believe that this can’t be fixed – it is an inherent problem in the current product.

    <=-=Jan 16 2008 10:03AM=-=>

    i ran in the exact same issue and i think it’s annoying. basically i have no idea of the ID’s of my partitions whereas i can enforce a naming convention in the partition name. in this way i can relatively easily process only the last partition. if i need to get the id of that partition, it’s not easy at all..

    <=-=Apr 8 2009 7:34AM=-=>

    amateurish isn’t…

  18. Report Builder - Corrupt SemanticModel on entity delete

    You can corrupt the SM by deleting a table from the DSV that is involved in role.

    1) Table A is related to table B which is related to table C
    2) In Entity /Table A select Role B � Expand inline and make some of Role B�s fields hidden
    3) In Entity / Table B select Role C - Expand inline and make some of Role C�s fields hidden
    4) Delete Table C from the DSV
    5) Build and you get errors (as you should)
    6) Delete Entity C from the model
    7) Build and error object required is…

    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. Reporting Services Wizard generated Analysis Services Reports empty

    If i create an Analysis Services Report using the Wizard the whole datasource/Query empties if i try to modify the 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 →
  20. Restore of transaction log fails using Management Studio

    If the transaction log contain multiple files some before and after when a full backup is taken then restoring using Management Studio fails. Transaction log can be restored using scripts but not use the GUI tool.

    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 20 2006 10:52PM=-=>

    This is probably the same bug as https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124718

    <=-=Jul 27 2006 12:17AM=-=>

    Thanks for your feedback.

    It looks like recovering full back-up is done with RECOVERY option (which is default choice in Options tab) and then restoring transactional log is done, and that is why UI throws valid error message from Engine

    This should have been done by restoring full backup with NO RECOVERY option and then restore from UI the transactional logs to restore successfully.
    I tired it this way and it works fine.

    Thanks,
    Gops Dwarak

    <=-=Aug 8 2006 1:10PM=-=>

    Thank you again for submitting this report. We will look at fixing this issue in the next major release of SQL Server. In the meantime, there is a workaround. Here is the sequence of that we think is going on and what should happen.

    1. Take one or more backup of the…

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base