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

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

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

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

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

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

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

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

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

  12. 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 →
  13. 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 →
  14. 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

  15. MSIT-MSO: Incorrect query in sys.dm_exec_trigger_stats BOL topic

    In BOL, sys.dmexectrigger_stats the Example section lists an incorrect query to get the top five triggers identified by average elapsed time.

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

    Thanks so much for your feedback. The documentation for the correct top five triggers will be corrected in a future Books Online release.

    Kris Froland
    SQL Server User Education

    <=-=Jul 26 2010 3:07PM=-=>

    The topic has been updated. Resolving this as a duplicate to item 232450.

  16. DTEXEC is not running after upgrading RC0

    We upgraded one of our production environments to SQL Server 2008 RC0
    After upgrading when we want to run an SSIS package in command prompt by using dtexec we get an error.
    Actually even if we run dtexec in command prompt the result is the same.
    we get an error message saying "This application has failed to start because DTEParse100.dll was not found. Re-installing the application may fix this problem"

    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 2 2008 1:44PM=-=>

    Thanks for sending us your feedback.

    We investigated this issue and its behaving this way by design. When customers upgrade from SQL Server 2005 to SQL Server 2008 RC0, the upgrade process does not remove SQL Server 2005 tools.

    Have you tried using DTExec.exe from this folder PROGRAMFILES\Microsoft SQL Server\100\DTS\Binn\? It should work. If it doesn’t please let us know.

    The workaround would be to set the “PATH” environment variable to include SQL Server 2008 binn path (i.e. PROGRAMFILES\Microsoft SQL Server\100\DTS\Binn\) before the SQL Server 2005 binn path (i.e. PROGRAMFILES\Microsoft SQL Server\90\DTS\Binn\) so that the right toolset gets used.

    Thanks,
    Ritu

  17. Once set in project properties, StartItem setting cannot be removed.

    Not a big deal but once set in project properties, StartItem setting cannot be removed.

    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. ASCMD does not return an Abend

    When using ASCMD utility to process cubes it incorrectly returns a successful error code when Analysis services is stopped midway during processing

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

    diteshonline.

    Thank you for reporting the problem.
    We are going to take a look at this and see what needs to be done to get this fixed.

    The Analysis Services Team.

    <=-=Aug 4 2008 4:25PM=-=>

    I have attempted to repro the problem both with SQL 2005 and 2008 RC0 and cannot. Both on WS08 64-bit and WS03 32-bit. Here is what I’ve attempted to do. See the attached scripts. Basically these scripts process an existing partition — and then while processing is on-going I stop the msmdsrv process using the OS Services applet. In all cases, ascmd detected an error and set the error level in the returned status. I’ve attached both the scripts and the results.

    <=-=Aug 5 2008 4:53PM=-=>

    Not knowing if you have Office 2007, I’ve saved as a .pdf and attached.

  19. MSFT - Maddog: Tapblock: Query returns wrong results!

    We have a query that returns different results depending on the columns included. This is obviously bad!

    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. MSFT: MSSales: RC1 -- Restart AS and gets Unhandled exception in Service Control when Timeout reached.

    Restarting Analysis Server using SSMS gives an unhandled exception when a timeout is reached.

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

    Hello -thanks for reporting. We’ve filed this as defect request and I go the following information from the Developer:

    This bug comes as a results of the size of the model. It takes time to load the cube metadata in memory. Meanwhile SSMS times out – if you use the Windows service control to start/restart the service you won’t see this issue.

    Thanks for reporting!

    Buck Woody, SQL Server Program Manager

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base