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.

Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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.

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

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

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

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

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

    In BOL, sys.dm_exec_trigger_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.

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

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

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

  14. RC0 RS - Tablix Header Does Not Remain While Scrolling

    When creating a new RS Report, you can not set the Column Headers to remain when scrolling after clicking on the appropriate checkboxes in 'Tablix Properties'.
    (See attachment 'Tablix Headers1.jpg')

    Another interseting item: When importing a previously created RS report (here from CTP 6) that already has the columns settings set to be visible when scrolling, you can not reset the tablix headers such that they are not visible when scrolling. If you unclick the 'Show Headers While Scrolling', the report's table will still have the column hears visible when scrolling.
    (See attachments 'Tablix Headers2.jpg' and 'Tablix Headers2a.jpg')

    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

    <=-=Jul 17 2008 11:20AM=-=>

    Thank you for reporting this issue. It is a known usability issue we will fix in a future release. 2005 table reports upgraded to 2008 do not contain a group header area. Fixed rows and columns are set with the FixedData property on the relevant tablix member. The “Headers remain visible while scrolling” options only apply if there is a tablix row or column header area. You can see them on the design surface above and to the left of the double dashed lines if these areas are in your data region. Drop a new matrix onto the design surface to see an example, matrix always contains a row and column header area. We will make enhancements to make this easier to set in a future release.

    <=-=Jul 17 2008 2:01PM=-=>

    I see how dropping a new matrix will let you do that now…

  15. Visual Studio 2008 freezes when a BI Project is left Idle for some time

    If I open a BI project, such as Reporting Services and Analysis Services, and leave Visual Studio idle for some time, Visual Studio 2008 hangs. I am unable to select any items in the project.

    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 24 2008 8:58PM=-=>

    Thanks a lot Teo for reporting the problem.

    This is likely problem with beta version of Visual Studio. We expect you should see this getting fixed with VS 2008 SP1.

    Thanks again for reporting the problem.
    Edward Melomed

    <=-=Aug 29 2008 6:38AM=-=>

    Not fixed with Visual Studio Service Pack 1. I leave an Analysis Services project open for a while and IDE freezes. The only way to get around it is to shut the devenv process inTask Manager.

    <=-=Jan 13 2009 1:04PM=-=>

    Any Word on this? Is there a hot fix for this bug?

  16. Invalid COPY-PASTE-operation behaviour for cyrillic text in scripts in Management Studio

    If I copy (CTRL+C) sql-script (from Management Studio) which contains cyrillic comments or strings and script is saved with default (ANSI) encoding or not saved yet then copied text is pasted (with syntax highlighting) into MS Word with wrong symbols instead of cyrillic ones. If I save script as Unicode (UTF-8 with signature) then cyrillic symbols are pasted into Word correctly. Unicode and Unicode (big endian) encoding behave like ANSI (incorrectly). If I paste code into Word or Notepad as plain text (using any file encoding) then cyrillic symbols are pasted correctly.
    I believe that it is not MS Word…

    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

    <=-=Jul 17 2008 2:06PM=-=>

    Alexey,

    Thank you for reporting the issue. Can you please let us know whether MS word had know issue of displaying cyrillic text on the settings? In the mean time, I will forward it to product team to investigate.

    Regards,
    Eric

    <=-=Jul 17 2008 8:09PM=-=>

    Thank you Eric.
    Unfortunately I din’t realize what you mean speaking about “know issue of displaying cyrillic text on the settings”. Can you please clarify?

    <=-=Aug 11 2008 10:21PM=-=>

    This also happens with Romanian symbols (a�st): if pasted as plain text they are fine, if pasted normally (as RTF) they show as “����”.

    Razvan Socol
    SQL Server MVP

    <=-=Jun 20 2011 12:47AM=-=>

    Hi Alexey,

    This is regarding connect item 356388. We looked into the issue carefully, but unfortunately it is not likely that we will be able to address the issue in the near future. Accordingly we are…

  17. one of the Newly Added column's don't replicate NULL value

    After adding 3 columns to a Table with the following schema data is not replicated for one of the newly added columns
    --commented columns are the newly added.

    I initially got this in a SQL 2005 64 bit environment and then when I test it with the 32 bit SQL 2008 RC0 same result.
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    CREATE TABLE [dbo].[TESTTABLE](
    [TESTTABLEID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
    [ID] [int] NOT NULL,
    [Code] [nvarchar](3) NOT NULL,
    [ERName] [nvarchar](30) NOT NULL,
    [ExCode] [nvarchar](10) NULL,
    [TSymbol] [nvarchar](12) NOT NULL,
    [INCode] [nvarchar](12) NOT NULL,
    [CSCode] [nvarchar](9) NOT NULL, …

    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. Microsoft.SqlServer.BatchParserClient.dll not included in Microsoft SQL Server 2008 Management Objects

    We are developing and testing against a SQL 2008 server. The required assembly Microsoft.SqlServer.BatchParserClient.dll is not included in the downloadable feature pack. I had to copy the DLL from a machine with SQL 2008 installed to the client machine. This assembly is not found after trying to use Database.ExecuteNonQuery Method. I believe this required assembly should be installed with the rest of the SMO assemblies.

    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 15 2008 4:31AM=-=>

    Hi,
    Thanks for reporting this issue. This issue is already fixed and will be available in next public release of Sql Server.
    Thanks,
    Sravanthi

    <=-=Jul 18 2008 1:42PM=-=>

    I had the same issue . I my case I installed the 32 bit version of SMO to windows 2003 server and it did not install Microsoft.SqlServer.BatchParserClient.dll which caused a problem during execution.

    <=-=Nov 24 2009 10:12AM=-=>

    It may be fixed as far as the assembly cach install process for smo , but it is not fixed for creating
    redistributable setup packages.

    I have sql express advanced editions with sp1 and vs 2008 with sp1 installed. I have a Report Installer setup
    package which uses an imbedded vb.net app as an execution event installer process. I ported this project to
    2008. I had to update the vb.net smo refferences to sql 2008, and it did not…

  19. Ragial gauge range dissappear after calibrating the scale

    1. Drop a radial range.
    2. Calibrate the scale.
    3. The default range disappears from the design image but it�s the Ranges collection

    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. SQL Server 2008 Express Advanced Password Expiration Checkbox Grayed Out

    After installing a fresh copy of SQL Server 2008 Express Advanced on Windows 2008 x64 Enterprise Edition I found that if I didn't uncheck the box for "User much change password on next login" during SQL account creation I could not uncheck it later because it was grayed out in the properties of that user. I had to delete my test database and test user and recreate them with this checkbox unchecked. I cannot alter SQL Server policies in this edition due to it being crippled, so this was the only workaround I found. Until I did this, no remote…

    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 21 2008 2:25PM=-=>

    Hello Crumb,

    Thank you for reporting this problem. SQL Server will prompt for the user to change the password the first time he/she logs into the server. If you would like to check/uncheck the option after the Login was created but before the user has logged into you could recreate the login. We will look at this issue for a future release of SQL Server.

    Thanks,
    Karthik

    MS SQL Server

    <=-=Jun 10 2011 6:42AM=-=>

    Hello Crumb,

    Thanks for logging the issue.

    We discussed and triaged the issue along with the other issues that have been logged in the SQL Server bug database, and due to other critical issues and resource and time constraints, we are not taking-up this issue for fixing it. We have taken note of this internally, and when we revisit this functionality in the future, we will try and get this…

  • Don't see your idea?

SQL Server

Feedback and Knowledge Base