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. SQL 2008 Audit missing Application name and Host name

    Auditing is a great feature in 2008 and helps in finding who is doing what and when but would be great to capture the Application name used in action and the host name where it is submitted from. These two key values are very importatnt for a complete audit trail.

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

    We’ll send you updates on this idea

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

    Upvotes: 10

    <=-=Sep 25 2008 6:06PM=-=>

    Hi,

    Thank you for your suggestion. Currently, you can obtain the client’s IP address from the Additional Info column if you add the SUCCESSFUL_LOGIN_GROUP audit group. The application name is unfortunately not available, but we will look into including this in a future releaes of SQL Server.

    Thanks,
    Il-Sung.

    <=-=Aug 26 2015 7:51AM=-=>

    Hi,

    My customer is a big financial institution and they have thousands of SQL Server. They have some basic auditing configured with Profiler traces across all of these servers. They want to use the Native Audit feature to replace Profiler traces, but they can’t because of these two missing columns – Application Name and Host Name. This is affecting their plans to use this powerful feature (SQL Audit) across thousands of SQL Server. Any updates on this request?

    Thanks!

    <=-=Oct 13 2015 9:57PM=-=>

    Hi

    I still cannot find the Application…

  2. Report Builder RC1 - Quick object finder

    Hi Team,

    Congratulation for the new version.
    Really better than a previous.
    however when we have a building error, the message error textbox1
    the problem is to find this textbox, could you provide a quick search of the object we have on the designer.

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

    We’ll send you updates on this idea

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

    Upvotes: 0

    <=-=Sep 24 2008 1:16PM=-=>

    Thank you for this suggestion, it is something that we’ve heard from others as well. We will consider adding this functionality in a future release of Report Builder.

    <=-=Sep 24 2008 1:31PM=-=>

    Only Report Builder 2.0 includes a “ribbon” so we need some more information or specific repro steps. It sounds like you are using SQL Server 2005 Report Builder. Is that correct? If so, are you trying to use the Find functionality for searching the report model or the find functionality while viewing the end results of the run report? Thanks.

  3. Need to guarantee release of Application Lock

    I am using an Application Lock to serialize a section of critical code in a stored procedure. In some cases, the client, a asp.Net application, times out and cancels the command while the SQL Server is executing the critical code, so sp_releaseapplock is not called at the end of the critical section, and the lock is never released. The web application uses connection pooling, so the connection persists and holds the lock.

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

    We’ll send you updates on this idea

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

    Upvotes: 2

    <=-=Sep 24 2008 9:21AM=-=>

    Thanks for your feedback. Here is the feedback from Dev

    Dev>> I don�t think that fixing the exception handling for the system SP is going to help. There are many cases where we cannot trap server-side errors in the catch block � some of the errors are batch aborting and you can only trap it on the client-side. This is a case where the customer has to release the lock just like say rolling back an uncommitted user transaction. Application locks are meant to be handled by the application logic

    My suggestion for the customer request is the following:

    Make the application code robust similar to say handling user transactions. You would check for @@TRANCOUNT for example and rollback an uncommitted transaction started from the client side

    <=-=Sep 24 2008 2:40PM=-=>

    I have modified my client application to deal with this problem, but I…

  4. Installing Report Builder as Stand Alone application

    We are currently using Report Builder 9.00.3042.00, which deploys as a cloick-once application. Many of our users do not have local rights allowing them to install applications, so these users have no means of accessing our ad hoc report facility. Is there a method for including this in the base image so that it does not need to run as a click Once application?

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

    We’ll send you updates on this idea

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

    Upvotes: 0

    <=-=Oct 13 2008 8:37PM=-=>

    Thank you for using SQL Server Reporting Services.
    click-once is an area we are investigating for a future release.
    thank you for your patience.

    <=-=Dec 9 2008 11:55AM=-=>

    Thanks for your feedback. In SQL 2005 we do not provide a standalone installer for Report Builder. However, this is available in SQL 2008 with Report Builder 2.0. Note that SQL 2008 Reporting Services is required.

    The download page is here:
    http://www.microsoft.com/downloads/details.aspx?familyid=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en

    Hope that helps!

  5. OPEN { SYMMETRIC | MASTER } KEY Password Parameterization

    Consider the following SQL statement to open a symmetric key, decrypting it by a certificate that has its private key protected by a password:

    OPEN SYMMETRIC KEY [MyKey] DECRYPTION BY CERTIFICATE [MyCert] WITH PASSWORD = '<password>';

    Since OPEN ... KEY SQL statements do not accept parameters, you need to formulate the SQL string as inline-SQL (YUCK!). Assuming your password is 'abc123', your SQL statement will look something like this:

    OPEN SYMMETRIC KEY [MyKey] DECRYPTION BY CERTIFICATE [MyCert] WITH PASSWORD = 'abc123';

    Nothing wrong there.

    Now assume we select a password of [';SELECT 'SQL INJECTION';--] (excluding the square brackets []), your…

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

    We’ll send you updates on this idea

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

    Upvotes: 12

    <=-=Sep 25 2008 2:39PM=-=> The tile for the bug is a little bit misleading as there is no direct SQL injection vulnerability in the DDL statement, but since there is no parameterization on DDL, it forces any application to use dynamic SQL by concatenating strings in order to generate the statement. Because using dynamic SQL opens the opportunity for SQL injection problems in case the user data (in this case the password) is not properly escaped. We definitely agree that there is a potential for improvement in this area, and I would like to generalize it a little bit more: Allow DDL parameterization for DDL that accepts passwords, including OPEN (SYMMETRIC | MASTER) KEY. We are currently considering how to improve in this particular area, but I would like to invite anyone who is forced to use dynamic SQL for DDL/DML to…
  6. Intellisense -- Collapse shortcut

    1.)It would be nice to implement a collapse outline feature which collapses regions of code with a quick shortcut key. For instance, if you have multiple nested begin end's it would be nice to collapse them to quickly get a visual if you are missing an end.

    2.)Also would be nice to have intellisense automtaically add the end in the correct tab placement when a begin was entered.

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

    We’ll send you updates on this idea

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

    Upvotes: 116

    <=-=Sep 19 2008 11:02AM=-=>

    Hello Exempo,

    Thank you for your suggestions. Intellisense is a new feature in SQL Server SSMS 2008 and it is expected to be enhanced over multiple releases. There were multiple features/enhancements that were considered for the first release but not all could make it due to timing constraints. Your suggestions on outline shortcuts and smart identing are indeed useful to the end user and will be considered for a future release of SQL Server. Please watch out this space for updates on this bug.

    Thanks,
    Karthik

    <=-=Sep 1 2010 1:08AM=-=>

    Still not looked at?

    Visual Studio had this for years. VS and SQSMS share a lot of common functionality.

    <=-=May 17 2012 4:34AM=-=>

    This feature would be most welcome. Using the work around for now.

    <=-=Jul 20 2012 1:31PM=-=>

    Hope this has been implemented in SQL Server 2012

    <=-=Mar 22 2013 9:06AM=-=>

    Thanks for…

  7. Embedded subreports for use with ReportExecutionService.LoadReportDefinition

    Our product uses ReportExecutionService.LoadReportDefinition to execute reports from templates stored in an enterprise content management system which attaches further workflows and policies.

    Executing reports in this way reduces the IT footprint of the product.

    Further development of the product is limited by the following problem:

    SQL Server Reporting Services do not currently support nested data regions (http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=336556).

    The common workaround is to use subreports.

    However, ReportExecutionService.LoadReportDefinition does not currently support subreports that are not stored in the report server's catalog.

    These problems require us to implement temporary storage management for subreport templates (rendering our use of LoadReportDefinition unnecessary…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  8. SSMS - Add multiple job enabling/disabling

    In SSMS when you open Object Explorer Details window (by pressing F7) and navigate to SQL Agent jobs there is an ability to select multiple jobs. But when you right-click on the selected jobs there are only Script and Delete options available.

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

    We’ll send you updates on this idea

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

    Upvotes: 7

    <=-=Sep 22 2008 11:49AM=-=>

    Hi,

    Acting on set of objects is something we are considering for the next release.

    Thanks,

    Gil

    <=-=Oct 26 2009 1:28PM=-=>

    I’ve resolved this bug as a Duplicate of another work item tracking this functionality.

    Thanks,

    Amy Lewis

  9. More feedback when running long operations

    I would like to be able to see how far through an operation isn (any operation) - so if sql is doing a scan of an index - it knows how many pages there are in that index so it could let me see how far through that scan it is.

    This way I would know when a long running query is going to take - it doesn't matter if it isn't totally accurate but just gives a feel for how long it will take.

    It would either give the seconds or preferably, give the percent of the way through…

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add Templates for Report Builder 2.0

    Report Builder 2.0 doesn't support templates.

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

    We’ll send you updates on this idea

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

    Upvotes: 18

    <=-=Sep 17 2008 3:19PM=-=>

    Thanks for your feedback. Many other customers have requested this feature as well. We are considering ways to add this in a future release. You may find that creating a “starting” report containing the essential elements, then granting users read-only access to it, is a reasonable solution in the meantime.

    <=-=Mar 25 2010 8:28AM=-=>

    This feature very important and should be resolved. If its good enough for Visual Studio SSRS developers, why wouldn’t it be for RB writers?

  11. Add Cardinality Indicator in Analysis Services Dimension Attribute Relationship Designer

    When creating and maintaining attribute relationships in BIDS/SSAS 2008, there is no visual indication in the designer of the Cardinality of the relationships.

    It would assist maintainability and troubleshooting if the Cardinality was exposed visually, much like the RelationshipType 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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add support for CSS and branding in report builder

    Currently there is no way to tailor the template(s) used by SSRS Report Builder to make user reports consistently exhibit companies' look and feel (and I understand from a news thread with Sean Boon [MSFT] that the situation is the same in SQL 2008/RB2). This is a major drawback for our users and our customers who want to use the product, because every time they create a new report, they have to spend the first five minutes adding logos, moving objects around, and changing textbox formats.

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

    We’ll send you updates on this idea

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

    Upvotes: 27

    <=-=Sep 19 2008 6:49AM=-=>

    Thanks for your feedback on Report Builder. These features are high on our priority list, and are frequently requested by other customers as well. We are working on adding them in a future release.

    <=-=Nov 30 2010 1:36PM=-=>

    Based on the age of this post and a lack of comments, everyone must be using another reporting solution. Would you mind sharing what that solution is?

    The ability to, at minimum, establish a template per client, or better yet, CSS Stylesheet support is crucial to any widespread adoption of this tool.

  13. Activity Monitor Windows Scrollbars and Sizes

    The "new" activity monitor, used in the SQL 2008 tools is not useable. On many servers, I have between 500 and 2500 connections and have to scroll a lot because I can only see 8 connections at a time in the process list.

    To get to the up/down scrollbar, there are two horizontal scrollbars on the bottom that I have to navigate on my narrow screen in order to get to the vertical scrollbar.

    I use a monitor flipped sideways to see long screens.

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

    We’ll send you updates on this idea

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

    Upvotes: 12

    <=-=Sep 16 2008 5:09PM=-=>

    Hi bryanivie,

    Thank you very much for reporting the issue on usability of the process list window inside the Activity Monitor. We will consider making improved UI designs, including your specific ask, in the next release of SQL Server.

    Shirley Wang

    <=-=Dec 4 2008 5:48PM=-=>

    I wonder sometimes if Microsoft employees actually use SSMS to manage their own production databases. Changes like this take SSMS one step forward (by adding the new tabs like CPU history and Expensive Queries) and two steps backward (by making the data harder to browse). If you compare the Activity Monitor in SSMS 2005 with that in SSMS 2008, you readily see that 2005 has horizontal scroll bars, while they’re gone in 2008. Additionally, 2005 has light gray column and row dividing lines, and they too are gone in 2008.

    Please reconsider adding back the horizontal scrollbars and restoring…

  14. Allow Rounded Rectangle report control

    Allow Rounded Rectangle report control

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

    We’ll send you updates on this idea

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

    Upvotes: 180

    <=-=Sep 17 2008 7:56AM=-=>

    Thank you for using SQL Server Reporting Services.
    We will review your comments/request for rounded rectangles for a future release.

    <=-=Nov 13 2009 6:10PM=-=>

    Hey, while you are at it, can you please add some drop shading to that puppy? What about a blend like you have in chart? And maybe a little 3D? Reflection? Glow?

    Give the people want they want! Power rectangles!

    <=-=Dec 29 2009 3:50AM=-=>

    Maybe adding a corner radius to the Rectangle would be just what we need, a rounded control would be to much.

    <=-=May 27 2010 12:25PM=-=>

    Yes please. Ability to specify rectangles with rounded corners and to set the size of the corner in millimeters

    <=-=Oct 25 2010 8:58AM=-=>

    Agreed — Tables, Rectangles, Text Boxes all need rounded edges — there is really not a reason not to.

    <=-=Nov 17 2010 1:13PM=-=>

    Agree. Tables, Rectangles, Text Boxes,…

  15. Deploying Reports For Different Environments

    Currently there is not way to easily deploy reports to multiple environements, like a dev, test and production environment. I believe other users have a similar problem except for it deals with multiple customers.

    Please see this Forum Post:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=91394&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  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  16. SSRS - Allow custom data extensions to launch the connection string builder UI.

    In SSRS, only out-of-the-box SSRS data extensions/providers are able to launch the connection string builder UI when configuring a new data source.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Export to Excel - Add workbook and/or cell protection

    We have many "power" users who likes to get their reports in Excel so they can manipulate them to their likings. Often times, this is what they are use to getting. However, some managers want them to have access to the data but not be able to change it. It would be nice to have the option to "protect" the workbook and/or cell.

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Provide ALTER Permissions at the Database Object Class Scope Level

    Currently, I can GRANT or DENY explicit CREATE TABLE, PROCEDURE, FUNCTION, etc. permissions at the Database Object Class level.

    In order to GRANT a particular object class (PROCEDURE for example), I must GRANT CREATE PROCEDURE at the database scope and ALTER at the schema scope levels. However, that ALTER SCHEMA permission exposes modification to every other object class within the scope of that schema. I must then explicitly DENY ALTER on every specific object within that schema that I want to restict modifications.

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

    We’ll send you updates on this idea

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

    Upvotes: 1

    <=-=Sep 2 2008 12:46PM=-=>

    Hi Anthony,

    Thank you for your suggestion. It’s too late to make any changes to SQL Server 2008 but we will consider this for a future version of SQL Server.

    Thanks,
    Il-Sung.

    <=-=Feb 11 2013 2:37PM=-=>

    Hi Anthony, Thank you for your suggestion. It’s too late to make any changes to SQL Server 2012 but we will consider this for a future version of SQL Server.

  19. Merge Agent auto resume when downloading snapshot

    When the merge agent is downloading a snapshot either compressed or not a communication error causes it to fail and it must start downloading all over again. International downloads to some countries can be trouble some and we have to use a more reliable download manager to get the cab file accross.

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

    We’ll send you updates on this idea

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

    Upvotes: 0

    <=-=Sep 16 2008 10:32AM=-=>

    We will take a look at this with other improvements for next release. Thanks

    <=-=Sep 16 2008 10:58AM=-=>

    Thanks for reporting this issue

    <=-=Jan 4 2012 4:08PM=-=>

    Hi Martin,

    We’ve looked into this. Although we would like to improve the product this way we will not have the means to do it in a foreseeable future.
    That said your feedback is very valuable to us, we keep track of the suggestion.

    Best regards
    Jean-Yves Devant
    Program Manager (Replication/CDC/CT)

    SQL Server Engine Team

    <=-=Jan 4 2012 4:08PM=-=>

    Hi Martin,

    I’m closing this discussion item for now.
    Best regards

    Jean-Yves Devant
    Program Manager (Replication/CDC/CT)
    SQL Server Engine Team

  20. Prompt for selection of a parameter in SSRS

    If you donot select a parameter "XYZ" in report and clicked on "View Report" button then the report will prompt as -
    Please select a value for the parameter "XYZ" .
    This error prompt should be editable to write in own words like-
    Please select "XYZ" .

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

    We’ll send you updates on this idea

    0 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Server

Feedback and Knowledge Base