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. RSClientPrint in reporting services errror

    This is a urgent needed for help... i got to put the release the application to a client but i can't while this problem isn't resolved...

    There is:
    When i try to print a report using RSClientPrint ActiveX object it give's me a error in the end of the request, but the report it's printed ok (just the error message appears)

    in attachement goes 2 files: report1.rdl and the printtest.htm

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

    <=-=Mar 28 2006 3:24PM=-=>

    I am not able to repro this issue. Here are a few things to try:

    Make sure you are using the SP1 print control. Your html still has the RTM version 1399 and should have the SP1 version you are using.
    Turn on the print control logging by setting the following registry value:
    [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Reporting Services]
    “LogRSClientPrintInfo”=dword:00000001

    This will create a log file in the temp directory called LOG.tmp. Send this file to us, it should have some information to help us debug the issue.

    <=-=Mar 29 2006 8:12AM=-=>

    Are you using the Reporting Services 2005? And the rsclientprintcab that comes with that?
    And, what SP1 Print control that you are talking? I don’t know any, and i tryed to find in the web and don’t found (for this version).

    The registry key that you gave me isn’t for reporting services 2000?…

  2. Attach databases from network drive without full control

    Opened new for FDBK45101, because wasn't in office for some weeks, so couldn't answer question.

    To attach database file on network shares the user must have full control on the files, because SQL2005 changes the permissions on the files in the way that another user account is not able to connect the database files.

    DBCC TRACEON(1807)
    GO
    PRINT 'ATTACH FIRST'
    CREATE DATABASE TEST ON
    ( FILENAME = N'\server\tmp\test.mdf' ),
    ( FILENAME = N'\server\tmp\testlog.ldf' )
    FOR ATTACH;
    GO
    PRINT 'Detach'
    exec sp
    detach_db TEST
    GO

    Permission before Attach:
    1.) Everyone Full control
    Z:\test.mdf Jeder:(OI)(CI)F

    Z:\test_log.ldf Jeder:(OI)(CI)F

    2.) After attaching:

    Z:\test.mdf…

    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 22 2006 9:56AM=-=>

    Hi, thanks for the further information that you have provided. Now we understand better the issue that you have run into. Can you verify to see if we understand this correctly? 1) You issued the first attach with account “domain\user”; 2) you subsequently issued the detach with account “domain\user”, too; and 3) then you attempt to attach the files with an account different than “domain\user” and got access denied error. If all above three are true, then the behavior you saw was by SQL2005’s design – you either have to use “domain\user”, the account that did the detach, to re-attach the database; or “domain\user” or admin should modify the ACL’s on the file to grant other people attach permission. I understand that this behavior may not work well in your scenario. But, could you please confirm with us about our above understanding first, please?

  3. Encrypted Database Backup and restore

    See theread below
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=308381&SiteID=1&mode=1

    Thread name Encryption and database restore

    Please assign to Laurentiu Cristofor

    Basically I have a database created on ony one of several machines with encrypted data in it when I backup and transfer this database to another machine I cannon create the asymetric keys or the symmetric keys encrypted with the asymmetric keys

    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 24 2006 6:04PM=-=>

    We are trying to repro this issue on one of our machines. On the first machine we restored the attached databases, the keys worked ok.

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

    We tried the backups on more machines, but we were not able to repro this issue. On all machines, the keys worked correctly after restoring the backups.

    <=-=Apr 5 2006 7:00PM=-=>

    Closing as NotRepro, as we have not been able to repro this issue on our machines. If you can get another database with a repro, let us know and we’ll investigate further.
    Thanks
    Laurentiu

  4. Object Explorer is really slow with lots of tables

    This is a test bug - please assign to billramo and make sure path = \Management Tools\Untriaged Customer Bugs

    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. 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 11 2006 11:24AM=-=>

    I have tried the steps you outlined below in RS 2005 SP1. They have worked for me: I was able to pass the credentials to main report and they were passed to the drillthrough report. This is a snippet from the master RDL I have used.

    Drillthrough =Parameters!ConnectionString.Value click here

    Please note that passing connection strings through report parameters URLs is not a secure method, I hope you only use it only for testing.

  6. Error While Launching SQL 2005 Profiler

    Only TrueType Fonts are supported while launching SQL Server 2005 Profiler

    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 24 2006 9:32AM=-=>

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

    <=-=Mar 27 2006 4:04PM=-=>

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

    <=-=Nov 26 2007 10:47PM=-=>

    Closing this as duplicate of another bug that tracks this issue for future release.

    Thanks

  7. Sql Server 2005 Express / Access97 Conflict

    installing the standard ODBC Drivers into Access 97, and installing the (useless) Upsizing Wizard utility from http://support.microsoft.com/default.aspx/kb/q237980/
    made it impossible to connect to the (running) SQLExpress Service

    also, when I went to re-install I tried to skip re-installing Visual Web Developer and Framework, with the result that the Control Panel would not even LET me un-install SQL Server Express anymore ...

    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 27 2006 9:48AM=-=>

    We are unable to reproduce your problem. When we installed the Access 97 Upsizing Wizard it had no impact on our ability to establish connections to an existing SQLExpress instance using ADO. If you can supply more detailed information about the problems you encountered, including details of applications used and error messages encountered, we will investigate further. Ideally we need complete step-by step instructions so we can be sure we are reproducing your steps exactly.

  8. Report-Columns get lost in a subreport

    I have a report with two columns. The report renders well and shows the two columns correctly. But when I place these report as a subreport, only one column is shown.

    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. ExecutePackage Task don't execute packages if "delayvalidation" is set to true in the package to be executed

    I need to run a package "A" in which connections are set at run-time. In order to run in with dtexec i have to set DelayValidation (on the package object) to True. With this option set to true in the same package "A" is executed from another package "B" using the ExecutePackage Task, the package "A" don't get executed since the package "B" reports a validation error on package "A".

    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

    <=-=Apr 26 2006 2:12PM=-=>

    Mauri,

    Can you share your package “A” and package “B”? I’m currently unable to reproduce the issue using your Repro Steps and description.

    Thanks,
    Patrik

    <=-=May 12 2006 11:48AM=-=>

    Unfortunately, we weren’t able to reproduce the problem given the details specified. If you are still experiencing the issue please do not hesitate to restart a dialog. Thanks.

  10. DHCP Not accessible after installing SQL Server 2005

    After a clean installation of windows 2003 server sp1 enterprise (latest updates), if you install sql server 2005 (all items) and restart the server, you are no more able to access the dhcp server (that is still working). The snapin always reportes unable to connect to dhcp server.

    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. The values for the type column in sys.user_token are incorrectly documented

    In the topic "sys.usertoken (Transact-SQL)", the possible values for the type column are documented to be:
    SQL
    USER
    WINDOWSUSER
    WINDOWS
    GROUP
    APPLICATIONROLE
    DATABASE
    ROLE
    CERTIFICATEMAPPEDUSER
    ASYMMETRICKEYMAPPED_USER

    However, if we try to read from this view in different scenarios, we will get values like these:
    SQL USER
    ROLE
    USER MAPPED TO CERTIFICATE
    etc.

    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 21 2006 5:56PM=-=>

    Thanks for pointing this out! I’ve fixed the format error in the source document. You should see this in the next web update. -willisj

    <=-=May 1 2006 1:59AM=-=>

    I saw that you replaced the underlines with spaces in Books Online SP1 (apr.2006). But it wasn’t just a formatting error: the text should be different, for example “USER MAPPED TO CERTIFICATE” instead of “CERTIFICATE MAPPED USER”, “ROLE” instead of “DATABASE ROLE”. (you can run the statement I wrote in the “Steps to Reproduce” section to verify this, but should get the correct values by talking to developers team).

    Razvan

    <=-=May 1 2006 8:12AM=-=>

    Hello. I appreciate the feedback. In some of the beta releases the view did return terms with underscores rather than spaces. That has been changed in the view and also in the documentation. Thanks!!…

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

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

  14. 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?

  15. 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,…

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

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

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

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

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base