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. Generated script of a view from SQL Server 2005 Management Studio Express CTP with the 'Script for Server Version' will not run in

    Script of a view generated with 'Script for Server Version' to 'SQL Server 2000' option using 'Generate Scripts...' from SQL Server 2005 Management Studio Express CTP will not run in SQL Server 2000. The script is generated with:

    IF NOT EXISTS (SELECT * FROM sys.views WHERE objectid = OBJECTID(N'[dbo].[v_GroupMembers]'))

    and results with "Invalid object name 'sys.views'." when executed in SQL 2000 Query Analyzer

    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

    <=-=Mar 24 2006 9:32AM=-=>

    Thank you for your bug report. We will investigate this for a future service pack.

    <=-=Mar 28 2006 8:44AM=-=>

    Quick update. We are placing this bug report under consideration for SP2.

    <=-=Apr 11 2006 12:04PM=-=>

    Thank you for reporting this. This issue is fixed in the SP1 release of SQL Server Managment Studio Express.

  2. Managmen Studio: Objects does not displayed in summary after error

    Managment Studio.
    In Summary double click Databases, Database, Tables. When try to open table get an error.
    After error Summary does not display any objects (dbs, tables, views etc).

    DB was converted from SQL2000.
    On AdventureWorks all 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: 0

    <=-=Mar 23 2006 6:44PM=-=>

    Hi gmsalex

    We could not repro the problem.

    What does it mean "DB was converted from SQL2000?

    While trying to repro we copied the Shiloh database to Yukon server by using Copy Database Wizard, and we could not repro it.

    Please feel free to activate this bug, if this is consistent repro , with more detailed repro steps of how DB was converted from SQL 2000

    Thanks,
    Gops Dwarak

  3. UNC file path backups

    UNC paths work for backups but not in removing old backup files.

    Although you can use a UNC path to backup to a remote server under a service account with rights to access the remote drive. You cannot use the maintenance cleanup task to remove dated backup files using UNC paths.

    When creating the path for the folder selection it gives the following error yet it work fine for the backup task.

    \webreports\backup\current\
    Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

    If you…

    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

    <=-=Mar 21 2006 3:16PM=-=>

    Hi Tim,
    Thanks for reporting this and we could mnot repro it in our lab

    We created a maintenance plan with two tasks
    1) Backup adventureworks to \\abc\def\adv.bak
    2) Deletes \\abc\def\adv.bak
    3) We specified that task2 should execute only on success of task1

    The file \\abc\def\adv.bak got deleted.

    Step 3 is very important because becuase that defines the work flow and executes the task in the right order.

    If you still could repro it. Please add detailed repro steps to the bug and reactivate the bug.

    Thanks,
    Gops Dwarak

    Did customer specify the order of execution?

  4. SSIS SMTP Initilise ERROR using Expressions When calling SSIS from Dotnet

    Error occurs only if calling SSIS from dotnet "Microsoft.SqlServer.Dts.Runtime", when using expressions to set SMTP server name, SMTP from address and SMTP to Address .

    Error Massage: The result of the expression "@[User::SMTP_ServerName]" on property "SmtpServer" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

    If calling SSIS from commandLine, no 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: 0

    <=-=Apr 20 2006 2:52PM=-=>

    Not able to repro. Able to execute a Send Mail Task in a dot net application when passing the SMTP Server as an expression

    The dtsx package is configure:
    1) Create a Variable SMTPServer string
    2) Create a Send Mail task with valid To, From and Subject
    3) Create a CM to a valid SMTPServer
    4) Click in the CM manager and from properties\expressions select Connection String with expression @[User::SMTPServer] (Drag and drop the variable value)
    Save the dtsx package

    Then using a C# application with Microsoft.SqlServer.Dts.Runtime;
    string pkg = @"g:\SSIS_SendMailTask.dtsx";
    Application app = new Application();
    Package p = app.LoadPackage(pkg, null);

    p.Variables[“SMTPServer”].Value = “K_Exchange_L1”; p.Execute(); if (p.Errors.Count == 0) Console.WriteLine(“Success During Execute”); <=-=Mar 11 2009 2:51AM=-=>

    I am also getting this error when running packages from an ASP.Net web app using Microsoft.SqlServer.Dts.Runtime. The error occurs when using expressions on the Send Mail task,…

  5. SSIS EXCEL CONNECTION ERRORS

    EXCEL FILES CONNECTION ERROR.

    1 vote
    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

    <=-=Mar 14 2006 12:44PM=-=>

    Thank you for using SQL server 2005 and SSIS
    Apologies but I am not exaclty clear of the problem. Do the connection errors occur when you create more than 1 connection manager for the Excel file, in the same package?
    Or do you have a single connection Mgr that you are using in a loop of some sort.
    Can you please include the erorr text you see?
    Thank you

    <=-=Mar 21 2006 3:17PM=-=>

    I can not repro the errors by trying out scenarios which have multiple Excel connection in a single pkg or a single Excel connection in a loop. Please reactivate if you can still repro and in that case please send more detailed steps to us.
    Thanks

  6. Rubbish error message when I try and run a package that isn't checked out

    If you try and run a package that is checked into sourcesafe then you get a rubbish, completely non-descript, error message that doesn't mean anything. You can see it in the attached screenshot.

    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

    <=-=Mar 21 2006 3:16PM=-=>

    We are not able to reproduce this error. Could you provide any information that might affect the scenario so we can repro this?

    <=-=Mar 21 2006 5:32PM=-=>

    We are not able to reproduce this error. Could you provide any information that might affect the scenario so we can repro this?

    <=-=Jun 16 2006 4:32AM=-=>

    Yeah, this was when using Visual SourceSafe (v6.0 I think) as our source control system. How did you try and reproduce it? For me it was simply a case of right-clicking on a checked-in package and selecting ‘Execute’.

    The project has since migrated to using Team Foundation Server but I’m not sure if the problem occurs there or not. I’ve left the project now so can’t check!

    Also, Microsoft Connect doesn’t show the attachment so I can’t see what teh original error message was.

  7. Error connecting to remote server when no password is saved

    I received this error System.Exception: CryptUnprotectData: Win32 error:-2146893813
    when trying to connect to a remote sql server (outside our network) using sql authentication, but without the password saved. It occurs when double-clicking the Server Registration name in my list of Registered Servers and when I select Object Explorer from its 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: 0

    <=-=Mar 13 2006 4:28PM=-=>

    Hi Corgalore ,

    We tested in our lab the scenario you have mentioned of not remembering the password during server registration and then selecting to see it in OE. This has expected behavior of prompting for password from connecting through IE and no error is seen.

    If you are seeing this consistenlty can you please update the bug with more detailed repro steps and the build number, OS details you are seeing this issue. It will help to narropw down the issue.

    Thanks for taking time to report this.
    Gops Dwarak

  8. Reporting services --problem exporting to pdf format

    We have a problem with the export of reports to pdf, and the viewing of reports on the ReportServer-pages.
    The preview in BI-Studio is correct, but the PDF and the WebView differ from that!
    Spaces and the Euro-Symbol get lost, although everything takes place on the same computer.

    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 →
  9. Duplicate table created from create script

    Somehow, I managed to create a duplicate table with the same owner by using a simple table create script and sqlcmd.

    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

    <=-=Mar 13 2006 11:40AM=-=>

    Thanks for reporting this. However, we cannot possibly help you without repro.
    My educated guess is that you have simple table name under different schema. E.g. foo.tbl1, bar.tbl1.
    Can you share the repro script with us?
    Thanks
    Andrew
    [MSFT]

    <=-=Dec 4 2007 11:23AM=-=>

    Hi Mat,

    We were not able to reproduce this issue. Can you please provide us with your script.

    Thanks,
    -Vineet Rao

  10. Hyperlink in subscription email has bad characters

    For specific subscriptions, text in the subscription hyperlink is overwritten by "! " which breaks the link. This issue is now holding up rollout of Reporting Services to production.

    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

    <=-=Mar 7 2006 6:12PM=-=>

    There is no attachment to this issue. Can you please attach RDL file and example of output?

    <=-=Mar 8 2006 9:06AM=-=>

    I have added an attachment with the rdl as requested. I have also added the stored parameters from the database and how they are rendered in the url in the email by the email delivery extension where the bug occurs.

    <=-=Mar 20 2006 11:36AM=-=>

    I have applied the CTP SP1 – however, Reporting Services 9.00.2040.00 still generates subscription emails with breaks in the hyperlink.

    <=-=Mar 28 2006 2:36PM=-=>

    This seems like a coruption after RS sends the email. Can you please have RS drop the email to the local file system and see if the file is corrupt.

    To do this in the RSReportServer.config file set SendUsing to 1 and set the SmtpPickupDirectory to a local directory. If the file is not corrupt…

  11. Msg 8624 with Server Running Low on Memory

    I attach the SQL Server error log for a development server. As you will see there is a serious stack dump.

    Please pass this on to your product team.

    The scenario in which it occurred was that there was a large (60GB) database on the server, which wasn't being used.

    Queries started displaying the following error:

    Msg 8624, Level 16, State 1, Line 1
    Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

    As soon as I took the large database Offline, the above error didn't occur but 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: 1

    <=-=Mar 3 2006 9:00AM=-=>

    Thank you for reporting this issue. Is this issue reproducible at will by taking the database back online? If yes, will you please let us how the best way to get in contact with you, so that we can collect all the necessary information to understand and resolve the problem? Also, it would be helpful if you could attach one of the dumps that were generated to the bug.

    <=-=Mar 13 2006 3:08PM=-=>

    Unfortunately we were unable to reproduce the issue based on the information provided. Please see the previous response to this bug.

    <=-=Jul 6 2012 1:19AM=-=>

    I no longer have access to this system, so I cannot provide you with any further info.

  12. log file viewer, wrong date format

    Log File Viewer
    Log File Summary
    The date format in main items is correct (02.03.2006)
    The date format in subitems is incorrect (03.02.2006)[month and day in wrong sequence]

    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

    <=-=Mar 2 2006 10:36AM=-=>

    Hi Rutishauser,
    Thank you for your feedback. This is a tricky scenario. I tested this by switching my regional setting to English(UK) which follows the EU date format. In the logviewer all date values were in dd/mm/yyyy format except for the dates recorded within the Message field. The message field records the info in the default US format however it is transposed appropriately in the viewer for the Date field. The resolution to this issue is partly by design for the message field while it is not repro for the other fields since all of them display in the machines regional setting format.
    I agree that reading the message field could be confusing at times but the value added by this change, if we were to even consider it would be quite small to the effort and the number of places we need to…

  13. Design Aggregation Wizard Fails

    Get an ugly error with no explanation when running the Deisgn Aggregations Wizard

    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

    <=-=Feb 28 2006 6:12PM=-=>

    Hi Christian,

    Thanks for reporting this issue – we’ll investigate.

    Regards,
    Richard Tkachuk (richtk@microsoft.com)

    <=-=Mar 3 2006 11:56AM=-=>

    Hello Christian,
    Can you tell us what the error message you are seeing is when you run the aggregation design wizard? If you see this error again and can provide the additional technical info (usually available by a button in the lower left corner of the error dialog) it would be very helpful. Also, if you notice any difference between the measure groups for which the wizard works and those for which it produces the error, this would be helpful as well.

    Thanks,
    - Matt Carroll (Matt.Carroll@microsoft.com)

    <=-=Mar 9 2006 6:06AM=-=>

    Couldn’t get back to you earlier as didn’t have active alerts on this.

    The error message doesn’t contain any more information other than:
    TITLE: Aggregation Design Wizard
    -—————————————-

  14. SQL Server 2005 Evaluation - Won't install - insufficient disk space - tried on multiple machines

    tried to instal on multiple machines (W2K, XP Pro) - each time it says 'Insufficient disk space on C' even though there are hundreds of gigs 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Mar 1 2006 9:24AM=-=>

    Thanks for reporting this error. We haven’t seen this before, so we need a bit more information from you. Can you let us know what your disk configuration is (and free space), what you were attempting to install (which features), and what directories (if any) you specified to install into?

    We would also need a copy of all log files (just zip them up) from ProgramFiles\Microsoft SQL Server\90\Setup Bootstrap\Log\Files.

    Thank you,

    -Jeffrey Baker

    <=-=Jan 18 2007 7:40PM=-=>

    I also tried to install SQL Server 2005 Evaluation and received the error message.

    There is not enough drive space on C:\ to extract the package.
    I have over 52 gig remainging on the C drive. What gives?

  15. DTS Wizard tab order not in sequence

    The Data Link Properties dialog tab order is not in sequence. After the "user name" textbox, the tab order should next be the "password" textbox. But after entering the username, a press of tab shifts focus to the "OK" button. Logically, the tab order should be username followed by password.

    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

    <=-=Mar 14 2006 12:04PM=-=>

    Thank you for using SQL Server 2005 and SSIS.
    The User Interface you note is not something we can change, it is part of the provider itself and you would need to work with the maker of the OLE DB provider. I believe there are several DB2 providers on the market, yours sounds like one that IBM itself licenses\distributes.
    Microsoft has one at http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/DB2OLEDB.exe

  16. Failed to retrieve dependency information

    Error using SSMS to generate script for all objects in database.

    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

    <=-=Feb 26 2006 12:54PM=-=>

    Have you checked the object ids to see what object they could be?

    I know there is an issue if you have a stored procedure that references a user-defined aggregate, see FDBK45518.

    In any case, you need to supply more information, for it be possible for MS to consider the bug report.

    <=-=Mar 27 2006 9:16AM=-=>

    Hi Al,
    Thank you for your bug report, but we don’t have enough information to reporduce this problem. If you have some sample scripts that you can attach to the report, please do so and reopen this bug report.
    Thank you,
    Bill Ramos

  17. Report Builder decimal error - part 2

    This attachment goes with the bug report called "Report Builder decimal error" - it is the actual "rdl" so you can see the underlying report

    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. File Import Data Conversion Errors

    Trying to import a pipe-delim ASCII file using Import/Export Wizard from SS Mgmt Studio. Not able to change the data types and successfully import the rows. There were integer, float, nvarchar and date/time data types in the source data. Changing the data type on import from nvarchar resulted in failure to completely load the data. However, a small portion of the data did load without error.

    The error report generated by the DTS is attached.

    I was able to import the data by leaving all data types as NVARCHAR(125). After I imported the data, I successfully modified the table design,…

    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

    <=-=Feb 24 2006 11:08AM=-=>

    Hi
    Thanks For bringing this to our attention.
    However, we need more info so as to proceed with investigation. Can you please provide us a piece of your source file which can reproduce your problem?

    Thanks
    Wenyang Hu from Microsoft
    p.s.
    By default, if the source data can not be converted to the destination type (the type you specified), the Flat File will error. However if you do not want it to fail, instead, when it happens put null (or truncated value) in the destination column, you can also do so by modifying the Error Output – in the generated package, edit FlatFileSrc, click “Error Output”, you will be able to change the Error Handling there from “Fail Component” to “Ignore” or “Redirect” for each individual column.

    <=-=Feb 28 2006 10:52AM=-=>

    Hello, can you please respond with additional informaiton?
    Thank you for your time.

  19. FTS Service is set to Manual yet turns itself on

    Often times when I am in SSMS I notice that the FTS service is running. It is set via the Configuration manager in MANUAL mode. I have reset it several times to Stopped and MANUAL yet it still starts somehow.

    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

    <=-=Feb 21 2006 1:16PM=-=>

    Hi akelly,
    Thank you for your feedback. I could not reproduce your problem with the steps you have indicated. Would you happen to have someother service marked as dependent on the FTS service? Check the dependcies tab of the serice properties. If FTS service is indeed started then SSMS is depicting the correct state.
    Thanks,
    Ramesh Singh

    <=-=Apr 4 2006 3:08PM=-=>

    if you start the SQLAgent service related to the instance then FTS is started.

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

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base