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 preview pane

    When you make a report with parameters the preview has issues. After pressing view report, after the report is rendered if you click on the report itself it sometimes refreshes the report or a GDI+ error appears. You need to reopen the report. This is a very common issue, Ive done over 200 reports from basic to very advanced with this issue appearing in 99% of them.

    Even after clicking on print preview some things like tables arent aligned to a rectangle as they would when printed out in PDF. Its not that common but it does happen.

    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. Mgmt Studio: File Extensions: Adding new Query Editor extension results in unrecognized original file

    This was initially written about in the microsoft.public.sqlserver.tools newsgroup on 2/17/2006 at 1:04 PM under the title "SQL 2005 Management Studio: File Extension: Adding: How to?"

    I'm working with GA Management Studio on Windows XP SP2.

    I have a file with a UDF file extension (user-defined function). When I open
    the file in Management Studio, I cannot execute the file.

    I'm going to Tools-Options, Text Editor, File Extensions. I then add the UDF
    extension with the SQL Query Editor Editing Experience. Click OK, etc. When
    I do so, nothing happens. Restarting Management Studio has no effect. I
    can't execute the…

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

    Thanks for the feedback and we will address this in future release

    <=-=Apr 24 2006 10:28AM=-=>

    We attempted to reproduce the bug you reported but were not able to do so. Following your steps to reproduce yielded the expected results – the second file with the custom extension was recognized as a SQL Query Editor file. Opening the file prompted us for a connection and allowed us to execute the script. If you are still hit this bug please re-activate this bug with the updated steps to reproduce the problem.

  3. TOP clause does not work with OPENQUERY()

    A select statement with a top clause selecting from an openquery returns all rows instead of the number declared by the top clause.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. SQL Server 2005 IDE Error - Framework 2.0

    When I am trying to browse the Database objects, if I select an item on the tree to the left and then click the summary page, I get an error about a .NET Framework issue. At that point, I have to shut down the IDE and come back in or I won't be able to see a list of items based on my selection from the object tree.

    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. Summery window "lost" data

    OS: xp sp2, Win2k sp4

    The summery window cleaned itself after delete (when I choose from it more then one object to delete). It show the object count, but no data is shown.

    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 27 2005 3:00PM=-=>

    Thank you for your bug report. Given the steps that you indicated in the report, we are unable to reproduce the problem. If you have more detailed steps that can help us reproduce the problem, please reactivate this report.

  6. Microsoft SQL Server Management Studio Express raises errors on inline comments.

    Microsoft SQL Server Management Studio Express raises errors on inline comments on lines like:

    CREATE PROCEDURE SampleStoredProcedure
    P1 int, -- Param 1
    P2 int -- Param 2

    AS
    ...

    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 27 2006 1:25PM=-=>

    This code worked for me:

    CREATE PROCEDURE SampleStoredProcedure
    @P1 int, — Param 1
    @P2 int — Param 2

    AS

    SELECT P1 = @P1, P2 = @P2
    go
    EXEC SampleStoredProcedure 47, 11
    go
    DROP PROCEDURE SampleStoredProcedure

    Could you supplement the bug report with a complete repro that demonstrates the problem?

    <=-=May 30 2006 2:44PM=-=>

    Hi Andy,
    Thank you for your feedback. We are unable to reproduce this in build 09.00.2047 – the SSMSE RTM build that we shipped with SP1.
    Thanks,
    Ramesh Singh

  7. Report designer hangs on preview tab with Delay Notification window

    When attempting to preview a RDL file in the Visual Studio 2005 Report Designer for SQL Server 2005 Beta 2, the IDE hangs with a "Delay Notication" box appearing. The box goes away and reappears without any resolution. Terminating the devenv.exe process is the only solution.

    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 →
  8. OLE DB Connection without DSN

    When writing a connection with a DSN using OLE DB provider a client is unable to locate SQL Server 2005 with a DBnetlib.dll error.

    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 29 2005 8:08AM=-=>

    To clarify the above statement: a connection without a DSN does not work, creating a DSN will work, and then once the DSN is deleted new connections continue to work even after client re-boots.

    <=-=Jan 4 2006 6:44AM=-=>

    Here is an added error message that I’m wondering how to repair. On an Active Directory authenticated network I make a remote connection to xasid9546\ia_team using the SA account in Management Studio and receive this error: Cannot connect to xasid9546\ia_team additional info: a connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 – No process is on the other end of the pipe.) (MS SQL Server, Error: 233)

    However, I am able to connect to xasid9546\ia_team using Windows Authentication.

    <=-=Jan 4 2006 11:30AM=-=>

    There is a fix to one error “0 – No…

  9. splash.hta not found

    Autorun cannot run splash.hta file when the DVD is inserted.

    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. SSIS Data Mining Query Task: Prediction Join "erased"

    After a given user creates a Data Mining Query Task in SSIS and saves the package or project, when another user opens the package or project, the contents of the "Query" tab in the Data Mining Query Task (the prediction join) is erased.

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

    Hello Paul.

    Thank you a lot for reporting the problem to us.

    Unfortunately it is too late for the current release of Analysis Services to take any action on this matter.
    We are going to take a look at this in the next release.

    Thanks.
    The Analysis Services Team.

  11. Management Studio DMX Query crash

    When trying to execute an DMX Query within Management Studio 2008 RC0, I get an error is produced:

    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 25 2008 12:33PM=-=>

    Lachender.

    Thank you for reporting this problem to us.
    Unfortunately it is very hard to say just based on the information in this case on what is happening with the SQL Management studio. Or whether the problem is with Analysis Services.
    To troubleshot some more we suggest you try and run SQL Server Profiler against Analysis Server.
    See if you get any server errors as responce to your query.

    The Analysis Services Team.

  12. MSFT - Maddog: PDW doesn't report scale data always on charts

    Sometimes the PDW server activity history reports don't include scale on all the charts, thus making the chart fairly useless.

    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 6 2008 10:06AM=-=>

    Hi Josh,
    We understand the problem and how to fix this. We are looking to include this in the first CU for 2008.
    Thank you,
    Bill Ramos

    <=-=Jan 2 2009 8:10PM=-=>

    Hi Josh – The issue is fixed in CU2 – I have download instructions in my latest blog at: http://blogs.msdn.com/billramo/archive/2009/01/02/case-of-the-missing-database-name-in-activity-monitor.aspx
    Thanks,
    Bill Ramos

  13. SSMS: Single column results to text: Regression and nvarchar/varchar inconsistency

    SSMS inconsistently space-pads string results for single-column result sets. Varchar-type results are padded to the column alias or maximum display length, but with a minimum width of 4. Nvarchar-type results, on the other hand, are not padded. This is both an inconsistency and a change in behavior from previous versions.

    Because of this behavior, it is impossible to produce in the results pane (for cut and paste where needed elsewhere, for example) the exact result of executing one or more single-column string-type selects. Saving results to a file retains the spurious padding.

    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

    <=-=Jun 30 2008 12:15PM=-=>

    Steve,

    The issue is understood in the use scenario. It could be a regression introduced from a fix for right-to-left scripting languages. In column aligned mode, it is by-design but other modes such as comma, tab and space separated modes, it should preserve the original behavior. I will escalate it to the product team.

    Regards,
    Eric Kang
    Program Manager, Microsoft SQL Server

    <=-=Aug 30 2011 3:42PM=-=>

    Hi Steve Kass

    Thanks for writing in to report this issue. We have added this to our backlog of approved fixes for a future release. I’m resolving as “won’t fix” for accounting reasons on our side.

    Thanks
    Sam Hughes (Product group PM)

  14. SSMS : URLs are underlined, why?

    SSMS underlines URLs, and does so in confusing ways (it doesn't always stop underlining when the URL ends).

    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 2008 12:26PM=-=>

    Aaron,

    Thank you for reporting the issue. IntelliSense parser ignores content of string but it seems like coming from VS editor module that SSMS QE uses. We will investigate the reason.

    Regards,
    Eric Kang
    Program Manager, Microsoft SQL Server

    <=-=Jun 28 2011 11:20AM=-=>

    Thanks for your feedback. This particular problem should be fixed in the next release of SQL Server.

  15. KPE - JHU - SSMS throws OutOfMemory exception on large result set

    Running a query with a large result set from SSMS results in an System.OutOfMemoryException in SSMS

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=Jun 27 2008 11:05AM=-=>

    capnsue,

    Can you please provide us more detail on the issue? Was it running on Result to Text mode or Result to Grid mode?

    Thanks,
    Eric

    <=-=Jun 30 2008 11:21AM=-=>

    The described behavior happens when you are doing Results to Grid.

    I just tried the same query with Results to Text and found different behavior

    Query returns some number of rows (can’t tell how many because the “rows” indicator at the bottom of the results pane remains at 0
    and then returns with an error that says “could not replace text”

    Results to file produces: (104831923 row(s) affected) and no errors

    <=-=May 28 2011 12:20AM=-=>

    Hi,

    This is regarding the connect item 353243 you previously filed. Given that there is a workaround for the issue (save to file) and comparing other higher priority issues, we are triaging not to fix this issue. Please feel…

  16. Role Security at different levels of hierarchy

    I have two roles that specify dimension security at two different levels of the same hierarchy. Visual Totals are specified on both roles. Each role works fine individually, but when a user is assigned to both roles, the visual totals don't work as expected. You see the grand total at the parent level.

    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

    <=-=Oct 13 2008 11:18AM=-=>

    BIHunter.

    Thanks for reporting the problme.
    The issue looks to be �by design� (though could look like not immideately intuitive ):

    If at least one role has visual totals disabled, then the user will see real totals even if other role enable visual totals (this is also for compatibility with Shiloh).

    In this particular case, the per-attribute visual totals settings are:

    Role1 Role2

    State Yes No
    City No Yes

    So no visual totals get applied on any attribute.
    We believe the solution is to enable visual totals for both State and City in both roles.

    Hope this helps.
    The Analysis Services Team

  17. CREATE GLOBAL CUBE does not support cascading many-to-many dimension relationships

    The CREATE GLOBAL CUBE statement does not support cascading many-to-many dimension relationships. It gives an error even if all measures and all dimensions are included. A single many-to-many dimension relationship is supported, but if more m2m relationships are chained together, the CREATE GLOBAL CUBE doesn't work.

    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

    <=-=Oct 13 2008 11:19AM=-=>

    Marco.

    Thanks a lot for reporting the problem.
    The current version of Analysis Services does not support what you are trying to do. We will take a look at your suggestion for the next release.

    Thanks again.
    The Analysis Services Team

  18. ClosingPeriod Function in Analysis services does not utilise partiton pruning

    I have an Inventory cube with a time hierarchy where the days roll into weeks and weeks into months and months into years.
    I have a base measure for inventory.
    the cube is partitoned by week
    When I select weeks 1-4 (which make up month 1) and select month 1 simulataneously and look at the trace in profiler, 4 partitons are accesed.
    I then created a calculated measure using the closing period funcion and again ran a similiar query for the same time period. This time all partitons in the cube were referenced and the query was much slower.
    I…

    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. Modify Stored Procedure from Object Explorer

    Create a procedure/function with commenting a Comment and try to modify the procedure by selecting the procedure in object explorer and clicking modify.

    Funny thing someone submitted the Bug last Year as per this forum thread still not fixed it.( what a ...)
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=862972&SiteID=1

    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. sp_helptext output loosing format of the code when displayed in grid...

    To get and edit a stored procedure source code I use the sp_helptext which sends the output to result pane. If the result pane is in text mode the code that is printed is retaining the the original format with tabs and spaces etc.

    But when the results pan is in grid mode (CTRL+D) and if I do select all rows and copy and paste the code into a new code window the code is loosing it's format. All the tabs are getting converted into a space.

    Regards,
    Ashok Guduru

    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

    <=-=Jul 9 2008 8:37AM=-=>

    AshokGuduru,

    Thank you for the feedback. This feature will be tracked as a feature candidate of future release.

    Regards,
    Eric Kang
    Program Manager, Microsoft SQL Server

    <=-=May 18 2011 10:35PM=-=>

    Dear AshokGuduru,

    We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

    Thanks for writing in to Microsoft.

    Sincerely,
    Deepesh Srivastava

    <=-=Feb 15 2012 11:40AM=-=>

    Eagerly looking forward to the fix,

    Krishna
    date: 02/15/2012

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base