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. Unclear deprecation of column alias in SELECT list

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/c10eeaa5-3d3c-49b4-a4bd-5dc4fb190142.htm

    Towards the very end:
    Transact-SQL, A string used as a column alias for an expression in a SELECT list:

    It isn't clear what exactly is deprecated. SQL Server supports two non-ANSI constructs for column alias:

    1. Delimit the column alias within single-quotes. ANSI dictates that if you want to delimit, use double-quotes. And, of course, SQL Server supports square brackets as well.

    2. The syntax:
    column_alias = expression
    ANSI SQL supports below two constructs:
    expression AS column_alias
    expression column_alias (this might have been removed from a later ANSI SQL standard)

    So, what exactly is deprecated according to BOL? Above…

    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

    <=-=Nov 4 2005 3:08PM=-=>

    The only syntax we are deprecating is ‘column_alias’ = expression. All other syntaxes are still valid:

    column_alias = expression
    expression [as] column_alias
    expression [as] “column_alias”
    expression [as] [column_alias]
    expression [as] ‘column_alias’

    I have updated the documentation. Thank you for your feedback.

  2. SSIS ODBC .NET provider does not work with Pervasive ODBC driver

    When creating a read-only odbc link from Pervasive without security the .NET provider does not work at run time from within SSIS. Curiously it seems to be able to run the query at design time, because it will populate the column mappings. Connecting through another ODBC provider (such as the one in Excel 2007) works fine. EDIT: Running the SSIS package in 32bit mode fixes 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 =Oct 12 2006 2:05PM= [Bulk edit] Thanks for reporting this issue, unfortunately we are not able to implement your suggestions (or fixes) in the Yukon timeframe; however we have considered this feedback useful enough that we have either: 1) Closed this bug as a duplicate of a (similar) parent tracking item in the next verison of our product, Katmai or 2) Moved this bug into Katmai as a parent tracking-item and grouped other similar bugs underneath it. Either way, we are listening to your ideas and considering them for the next version. In some circumstances we have actually made a few changes in SP2 to address some of these issues too. =Oct 12 2006 2:09PM= Sorry – this bug was actually moved to SP3, not Katmai =Apr 2 2007 1:28PM= Hello Peter. We have recently made available a whitepaper describing connectivity in SSIS. From looking at this…

  3. SSIS: Script task breakpoints have no effect if the script task is in an eventhandler

    Script task breakpoints have no effect if the script task is in an eventhandler

    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 =Oct 12 2006 2:05PM= [Bulk edit] Thanks for reporting this issue, unfortunately we are not able to implement your suggestions (or fixes) in the Yukon timeframe; however we have considered this feedback useful enough that we have either: 1) Closed this bug as a duplicate of a (similar) parent tracking item in the next verison of our product, Katmai or 2) Moved this bug into Katmai as a parent tracking-item and grouped other similar bugs underneath it. Either way, we are listening to your ideas and considering them for the next version. In some circumstances we have actually made a few changes in SP2 to address some of these issues too. =Oct 12 2006 2:08PM= Sorry – this bug was actually moved to SP3, not Katmai =Jan 22 2007 2:24PM= Thank you for reporting this issue. It should be fixed in later version of SSIS. =Dec 13…

  4. The MDX exponential operator "^" is not documented, even in the latest BOL drop

    The exponential operator ^, as in 7^2 = 49, is not included in the operators reference page for MDX (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/mdxref9/html/1cdb8c31-a5f6-4430-b509-f81344f4622a.htm). This may indicate other base operators are missing as well.

    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. Setting SMTP ConnectionManager Runtime Expressions

    Using Variable to set the Expression for the SmtpServer. Then setting the variable as a runtime parameter, the connection string does not get evaluated to the runtime setting of the variable. It continues to use the value set statically on the variable within the package.

    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 21 2006 3:04PM= Thank you for using SQL Server Integration Services. We are investigating this issue. For now, One work around is to create a property expression on the entire connectionstring property rather than just the smpt server. =Jul 24 2006 9:09AM= I have attempted to set the connectstring property, using expressions and user variables, but it fails to validate that the expression is valid. Do you have an example of an expression setting the connection string where the smtp_server would be a user variable? If so, I will give that a try. Thanks. =Nov 16 2006 7:32AM= Not Able to Repro on RTM build DTExec /F package.dtsx /SET “\Package.Variables[User::SMTPServer]”;“GOODSMTPServer” OS: Win2003 SP1 x64 and x86 SSIS: RTM Dev ENG =Nov 16 2006 7:33AM= Not Able to Repro on RTM build DTExec /F package.dtsx /SET “\Package.Variables[User::SMTPServer]”;“GOODSMTPServer” OS: Win2003 SP1 x64 and x86 SSIS: …

  6. xml schema collection does not properly validate an xsd:dateTime

    An xml schema collection will produce an error when it tries to validate an xsd:datetime that does not end with Z. As far as I can tell from the XML Schema rec' the Z is optional. Other schema validator accept as valid xsd:datetime without a Z at the end. CREATE XML SCHEMA COLLECTION TimeTest AS '<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema&quot; targetNamespace="TimeTest"> <xsd:element name="date" type="xsd:dateTime"/> </xsd:schema>' DECLARE @x xml(TimeTest) SET @x='<date xmlns="TimeTest">2002-10-10T12:00:00</date>' /* Produces this error Msg 6926, Level 16, State 1, Line 3 XML Validation: Invalid simple type value: '2002-10-10T12:00:00'. Location: /*:date[1] */ -- works as expected DECLARE @x xml(TimeTest) SET…

    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: 6 =Sep 8 2006 3:52PM= Dear Dan Thanks for your feedback. You are indeed correct that XML Schema allows values with and without timezone to be validated and processed and that our other validators support it. However, since the SQL Server architecture does not support such a complex datetime type yet, we had to make an implementation decision on whether to support only values with or without timezone in the SQL Server 2005 release. After consulting several hundred beta customers we decided to require the timezone. Current workarounds include: 1. Change the schema type to xs:string (you will lose operational semantics) 2. Store the XML data without a schema constraint, perform the schema validation on the mid-tier or use the SQLCLR to write a function that passes the XML and XML Schema to the validator. 3. Make sure that the generated values associate a timezone. We are working on…

  7. Modal Windows Displaced Erroneously on multimonitor PC

    Provided I use two monitors with my laptop, when I disconnect one of them, some modal windows (e.g. the one for deleting a table/object) is displayed erroneusly with a "negative" offset, id est, it goes where it thinks the 2nd monitor shoul be.

    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 =Oct 12 2006 4:19PM= Hi Giovanni Costagliola, We are going to see if we can repro this in our lab. We’ll keep you informed of our findings. Thanks, Terrence Nevins SQL Server Program Manager =Jul 3 2007 11:29AM= Hi Giovanni, This issue has already been submitted. You can track it using: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=154063 Thanks, Dan Lead Program Manager SQL Server Manageability =Jul 3 2007 11:30AM= Sorry – I updated the wrong item. This is the active item. Please ignore my previous comments. =Oct 25 2007 7:53AM= Thanks for this feedback. I have converted this request to either a defect (something is broken) or a Design Change Request (something new to add to the product) and so I’ll close this ticket out. We will consider your information for SQL Server 2008 or a subsequent release. Thanks! – Buck Woody, SQL Server Program Manager =Jun 30 2011 3:33PM= I am guessing…

  8. Output 0 Buffer in DataFlow Script Component is not Accessible

    When you have a Script component in a Data Flow, the Output0Buffer is not accessible in Script 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1 =Jun 27 2006 10:41AM= This is the expected behaviour caused by the fact that the default “Output 0” is syncronized with the “Input 0” hence all the output columns from “Output 0” are added to the Input0Buffer wrapper class. However when you add another output it is created asynchronous by default (this can be changed using the SynchronousInputID property of the output) and because of that a new buffer is created for it and along with that a new wrapper buffer class in the script transform. Silviu Guea, SQL Server IS This posting is provided AS IS with no warranties, and confers no rights. =Jun 27 2006 10:41AM= This is the expected behaviour caused by the fact that the default “Output 0” is syncronized with the “Input 0” hence all the output columns from “Output 0” are added to the Input0Buffer wrapper class. However when you add another…

  9. SSRS 2005 Report Builder Bug: Chart Y-Axis numbers cannot be format unless the chart has multiple series

    SSRS 2005 Report Builder Bug: Chart Y-Axis numbers cannot be format unless the chart has multiple series. If the chart has only one series, the Format dialog box present only the Font tab; when the chart has multiple series, the Format dialog box present the Number tab as well as the Font tab.

    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. Restore using Mgmt Studio only recognises first dump in backup device

    Management studio only picks up the filelist (for display) of first dump in backup device in option page of restore dialog box

    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 =Jan 26 2006 5:16PM= Hi Sukhdev, Thank you for your feedback. We will review this for a future release. Thanks Ramesh Singh =Mar 27 2006 8:36AM= Quick update. We are placing this bug report under consideration for SP2. =Jun 26 2006 6:14AM= Thank you for providing feedback. This bug will be addressed in Future Service Pack Thanks, Alok

  11. Can't change install / destination dir.

    Expect to be able to change installation directory.

    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 2:33PM= Indeed, if you only change the destination diretory in the Setup dialog, it’s only a minor part of a full setup that gets relocated. However, you can edit HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\ProgramFilesDir and CommonFilesDir to have things installed somewhere else. Changing the TEMP and TMP moves even more stuff away. You still get quite a few files in C:\Windows\Installer. The only way I’ve found out to work around that is create a new partition and mount it as C:\Windows\Installer. I like to stress that I have no ideas whether any of the workarounds I’ve suggested are actually supported. =Jun 5 2006 3:00PM= Thank you for your feedback. We will look at adding this functionality in the next release. Thank You, Peter Saddow =Oct 12 2007 9:30PM= Microsoft comments: Thank you for your feedback. We will look at adding this functionality in the next release. Thanks,…

  12. Installation on a compressed/encrypted drive

    Actually the bug is for the 'shipping' 2005 version. When you [try] to install on a compressed/encrypted drive the installer reports an error that you can not do this. But previous versions allowed you to do this [even if it's not the preferred method]. Perhaps the new version could still allow this. The actuall bug is that clicking the help question mark on the error dialog takes you to the incorrect help. The help was/is related to 'authentication' method which is not the problem at all.

    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 =Nov 30 2005 7:08PM= Thank you for your feedback, We are considering fixing this issue in a future version of SQL Server or service pack. Radu Singer =Oct 12 2007 9:20PM= Thank you for your feedback. We can not support install on a compressed or encrypted drive. So we have closed this request. Thanks, Amy Lewis

  13. Scrollbars reset when using two vertical groups

    When using two vertical groups in Management Studio. The scroll bars get rest when moving between the tab groups.

    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 =Nov 22 2005 1:35AM= This applies to the result grids and not the queries =Nov 22 2005 1:32PM= Hi Simon, Thank you for your bug report. We will investigate the issue and address it in a future release, if required. Thank you, Ramesh Singh =Dec 13 2005 10:28AM= targetted for Katmai only

  14. :Quit does not get highlighted as a SQLCMD statement

    :Quit does not get highlighted as a SQLCMD statement.

    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. Can't display cube partitions after deleting some existing partitions

    My cube has around 40 partitions. After deleting around 20 partitions, the Development Studio can't display the existing partitions. Instead it displays the red X cross on the partition tab.

    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 →
  16. Removed Users are not actually removed in the Schema Properties dialog box

    A user removing from the Schema Properties dialog box is not really removed after clicking Ok

    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 =Nov 4 2005 7:56AM= Hi Michael, Thank you for your detailed bug report. We were able to reproduce the problem and we will address it in a future release. Bill Ramos =Mar 31 2006 7:56AM= Quick update. We are placing this bug report under consideration for SP2. =May 30 2006 2:04PM= Hi Michael, Thank you for your feedback. The remove user functionality is more so as to remove a user from the list only when all the persmissions to the user have been revoked. If any permissions to the user are still granted then the remove does not work. There is a distinction between Remove users & Revoke permissions on this dialog. Let us know if this does not resolve your issue. Thanks Ramesh =Jun 3 2006 2:25PM= No, that does not fly. The function of the dialog must be one of: 1) Pressing Remove revokes all permissions…

  17. Cannot run a SSIS Package which is under Source Control but not checked out

    It's not possible to run a package which is under source control without checking it out. With multiple developers working on these scripts having to check them out to run them is very disruptive as they are locked regularly.

    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 2 2006 2:52PM= Thanks, we are aware of this problem. As workaround, you may check out the modified file before running it, or start it using Debug > Start Debugging menu, which prompts to check out the file. We are considering fixing the problem for the next service pack. =Jul 29 2011 3:41AM= The Debug >Start Debugging workaround fails if other user has the package checked out with ‘0×80030005 Acces denied message’. If other user has the file checked out you can remove the writeonly attribute of the .dtsx file and try to run it.

  18. Management Studio Add New Column for a table

    When trying to add a new column using management studio, it sets to the default datatype's length even though it had been hand-typed.

    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 =Jan 3 2006 11:32AM= Hi Choongseng, Thank you for you feedback. I have been able to repro your problem however there are multiple alternative solutions that can be used such as the enter key, using the mouse etc. We will investigate at fixing this in a future release however this will not be in near future SP. Thanks Ramesh Singh =Mar 31 2006 8:12AM= Quick update. We are placing this bug report under consideration for SP2.

  19. Summary Page Error

    When the summary page is displayed the items in the tree are displayed. If all items in the summary page are removed the summary page gets an unhandled exception error from the framework. This disables the summary page.

    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 =Apr 12 2006 2:28PM= Hi Craig. I want to let you know that this issue has been entered into the backlog of work for the next general release of SQL Server. I also want to thank you for taking the time to provide us with the details (including great repro steps) of this bug. We really appreciate it. Thanks again, Terrence Nevins SQL Server Program Manager

  20. Management Studio Template Explorer (Vorlagen-Explorer) context menu (keyboard) not working

    The context menu in the Template Explorer (Vorlagen-Explorer) is not working when pressing the context menu key on the keyboard. The context menu of menu bars is shown instead of the context menu of code snippets. Right-click with the mouse displays the correct context menu.

    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 =Apr 11 2006 9:00AM= Quick update. We are placing this bug report under consideration for SP2. =Apr 11 2006 9:48AM= Quick update. We are placing this bug report under consideration for SP2. =Jan 22 2008 6:46PM= Hello migeold, This issue has been fixed in Yukon SP2. Regards, Rajesh

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base