Answer Questions

• Alex2200 Permissions

  I posted a problem with connecting programmatically last week. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=590672&SiteID=1 Nobody seemed to have any suggestions, however since then, I've mucked things up and recovered to the same problem and now I've mucked things up again in a different way. Also last week  I didn't mention that I was running my connection through remote desktop. That apparently can be a problem although not the fix. I'm still getting the ServerVersion member status set to "'this.conn.ServerVersion' threw an exception of type 'System.InvalidOperationException' when I try to create a SqlConnection . I still don't understand why. But when I try to open the connection I now get the follo ...Show All

• Asifkhan75025 export PDF under a button click

  How can I realize export PDF under a button click in my ASP.Net 2.0/SQL2005 application Any example will greatly be appreciated. Use the code inside Main() only. Thanks you very much for your help. This seems a windows application, is there any example for web application will this work in a web application: static void Main(string[] args) Why do you think the code is Windows application-specific The ASP.NET ReportViewer control will allow you to export a generated report to any of the supported formats, but if you need to do so programatically here is how you can do it. Replace MHTML with PDF in the sample code. ...Show All

• Umberto SQL Server Express EULA

  Hello, I want to use SQL Server Express 2005 as the database server for a commercial web site. Web site users will have both anonymous and non-anonymous access to web pages on the site (generated from data in the SQL Server Express database). Is this kind of use within the EULA of SQL Server Express 2005 I notice the EULA includes the following line in section 4 (you may not): * use the software for commercial software hosting services. It sounds like it might exclude using SQL Server Express as described above. Anyone know the intention of this clause Does this include shared hosting environments In others words, when SP1 is released with will we be abl ...Show All

• user__2006 SQL 2005 Client Tools

  I have to deploy the Client Tools to a dozen or so computers on our network. We currently use SMS to deploy our software and the intention is to use this to deploy the client tools. Can anyone advise on the best way to do this Thanks The tools for SQL Server come with their own MSI, you should be able to deploy them using the command line from SMS. There are multiple MSI files within the setup folder, any idea which one I should be using Do you know how to install only the managment studio portion I am not sure of the tools install msi, can you help I believe they should be wrapped in a setup.exe in the root ...Show All

• abhi_rock_star Custom SSIS Task Deployment

  I've written several custom Control Flow and Data Flow components for SSIS. I'm trying to deploy a new Control Flow Task, however it will not show up in the "Choose Toolbox Items" window. I have my dll's all in the right place. Because of other painful issues we have not used the GAC, and instead have put our DLL's that are referenced in the following directory: C:\program files\Microsoft SQL Server\90\DTS\Binn. This has worked fine for other custom tasks, but not for this one. The only things that are different about this transform are the following: 1. Not only does the task inherit from Task, it also implements two interfaces that I wrote. 2. One of the assembly references is actualy an executable instead of a dll. ...Show All

• JDPeckham Unexpected Timeout

  I recently migrated our Reporting Services database from 2000 to 2005 and to a new server. Most reports are working great, but one is not. It generates this error message: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. in the Reporting Services logs, I get this detail: w3wp!library!9!12/05/2006-10:14:08:: i INFO: Call to RenderFirst( '/Accounting/Invoice' ) w3wp!chunks!9!12/05/2006-10:14:08:: i INFO: Returning old chunk for: (8e08d754-26ce-43e1-b4ec-5f176febb4e2, 'CompiledDefinition', 0) w3wp!runningjobs!7!12/5/2006- ...Show All

• wpm methods of storing the Connection String in package configuration

  hi! I want to store the value of the Connection String in an Common table exisiting for the whole project and retrieve it for the whole package to Run. I want to know if there is a way of doing this. I do not want to have a config file which is created trhough the package configuration. In case of Parent package variable the Value of the variable needs to exist which again needs to execute the SQL Task which requires a connection string. In case of Environment variabIe.I have very less knowledge about the environment variable . Even if we store it how can we access it and change it in client place. In case of SQL server . Can we store in an existing table. what is the configuration filter what is the vlaue for it. I do no ...Show All

• lordali subset_filterclause not applied at the subscriber

  I am using merge replication between SQL Server 2005 and SQL Express. Some of the articles in my publication have filter conditions. Changes to subscription databases are being applied to the publication database without regard to these filters. The easiest way to see this problem is to create a merge publication with a single table article with @subset_filterclause of '0 = 1'. Any inserts to the publication database will not be propagated to the subscription database, but inserts to the subscription database will be propagated to the publication database. Can this be right If I set the subset_filterclause to '0=1', I do see proper results: 1. publisher inserts do not go down to the subscriber. 2. Subscriber inse ...Show All

• AndrewBadera SQL Server CE and Memory Issue

  Hello, Have a query that consistently gives back the following message. Not enough storage is available to complete this operation The query I'm using is a little more complex than what I'm usually using. It uses Case, has extra characters in the formatting like (i.e. '-------'), connects 2 databases. Free memory can be as much as 3 MB  on the Pocket PC before sending the query and I can still receive the above message. Was wondering if there are any ideas on how to prevent to much memory from being used. Have tried GC, disposing/reconnecting to the database before it calls query, but doesn't help. (have read somewhere SQL Server CE is unmanaged code and GC doesn't help clear up extra space). Thanks, Peter Yes. I am using SQL ...Show All

• CSharpCoder Report Caching with security

  Hi, I am trying to do caching in reporting services. Restricted access to data should be done along with caching. But once caching is done data restriction is not happening. Filter of data for the user credentials is not working as credentials are stored in the report server. Please help. Thanks in advance Meenu ...Show All

• fruce SQL Server 2005 64 bit vs. SQL Server 2005 32 bit

  Hi, We were planning to upgrade our SQL Server 2000 database to SQL Server 2005 to leverage the performance improvements in 2005. For the upgrade we were thinking of SQL Server 2005 32 bit and SQL Server 2005 64 bit and hence did the performance testing on the both the versions. To our surprise 32 bit version performed much better than 64 bit. For 64 bit we also increased the RAM from 16GB to 64GB. Could anyone pls explain why this is happening We had an understanding that 64 bit will definitely perform better than 32 bit. Does query plan differ for 32 bit and 64 bit SQL server 2005 Thanks in advance Ritesh We ran the same batch in both the environment noted the executio ...Show All

• laja Does the evaluation version have Analysis Services?

  I've downloaded and installed it, but I'm not seeing anything that looks like any sort of OLAP tool.... Obviously, I'm completely green... Thanks for the reply, David. I don't see Analysis Services even listed in my Services, so I'm guessing that it doesn't, in fact, come with the evaluation version of SQL Server 2005. Does anyone know how I might obtain an evaluation version of SQL Server 2005 that does come with Analysis Services Hi Mr. Turtle, The Trial edition has the same features as the Enterprise edition of SQL 2005, so it should have Analysis Services. Two ways of checking. 1. Look in your Administrative Tools and Services and you should see SQL Server ...Show All

• ACHawk Getting Column name when processing Error Ouput

  I am working on a SSIS package. I want error records to be redirected to a different table. Natively, the package passes the Error Code and Column Code (don't know what to call it, but it's a number). I found a script to get the error description, but can't find an equivalent to get the Column name. Any ideas Row.ErrorDescription = _ Me .ComponentMetaData.GetErrorDescription(Row.ErrorCode) It's not going to be possible. See: SQL Server Feedback Item 168857 Try this: http://sqlblogcasts.com/files/3/transforms/entry2.aspx Thanks, S Suresh Suresh, This looks like exactly what I need. Unfortunately, when I try to run it, I keep getting ...Show All

• Ernesto_RD Templog Optimization in SQL 2005

  I know for the TempDB data files I should have as many files as I do CPUs for best performance, but what of the log The one thing that bothers me is that I have a bunch of disks, in fact I have a raid 10 of 6 disks of just the TempLog file. Is that overkill My thoughts are yes, because there is only one file and since it is the log file everything is already sequential and therefore I should get the same performance as if I were to put it on just a mirrored pair Any thoughts would would be appreciated. Rich Hello Rich, The real answer is monitor your tempdb log using perfmon IO counters. My favorite counters are Avg Disk Sec/write and Avg Disk Sec/read. Of course the activity will most likely be writes. The key is to ...Show All

• bishoycom Jump to URL

  Hi, I have made a report consisting of links to other reports. I open the links via the "Jump to URL" functionality. Is there any way of opening the links in seperate browser windows My users would like to be able to have more than one report open at a time. Thanks for any help :-) -- Heidi -- My links are defined in a table as a simple textbox with navigation. How can I insert javascript to this code Now I have the following in my jump to url: = window.open(Fields!filename.Value)" where Fields!filename.Value contains the URL to my reports. When I click the link I get an error saying " ) expected" My links look something like this: http://myserve ...Show All