Answer Questions

• ubm0158 Getting Error when calling a SQL Server Report with Paramter from asp.net page using Report Viewer.

  I have impletemented SQL Server Report using my analysis service in my localhost/reportserver. The report has a multi-valued parameter. Depending on the paramter selection it create dynamic report. It is working great in my report server. I have to integrate the reports to my asp.net project which is also writen in VS 2005. So I add an asp.net page and put Report Viewer control on the page to connect with the server report. Using smart tag, I gi ...Show All

• Benjaminhf Column ''cb.CurrentBalance'' is invalid in the HAVING clause ...

  Not sure why I am getting this error below.  It has someting to do with my CurrentBalance calculation portion in my INNER JOIN area:   Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. SELECT   rm . rmsacctnum AS [Rms Acct Num] ,           & ...Show All

• manilahunk Pipeline buffer leaks

  Any tips on how to deal with pipeline buffer leaks that are appearing when looping round a package multiple times.  Also any information on whether tweaking DefaultBufferRows / Size or threads would be helpful... (this is all stuff that either worked or wasn't as bad in the Dec CTP.. so much for progress....) This was a bug that has been fixed. There is no work around for this in the June CTP, but it ...Show All

• voko Change an Access Database to SQL Server

  I designed a database that works well in Access and I want to get it to run in SQL Server. How do I learn how and what to do to change over to SQL Server I also use SQL Server 2005 on Windows XP pro, and haven't experienced any limitations (when compared to using Windows 2003). What errors are you getting Also have a look at the event log, and ensure you resolve any permissions issues first. ...Show All

• Filipe Fernandes SQLExpress on a dual core processor

  I've just been reading a bit on SQLExpress. One of its limitations is that is only supports 1 processor. What would actually happen if it was installed on a dual proc box And what would happen on a dual core processor Regards Graham I would agree with the other posters here that it would seem that 1 CPU means any number of virtual processors including across dual core or hyperthreads, but can someone from ...Show All

• Sreejumon MVP Help in Generate Specefic Sql Query

  Happy Neew Year to all. Can Anybody help me with next. I Have Two Tables. TableA and TableB. In TableA each row have 4 fields : 1) DATETIME 2) X 3) Y 4) ID in TableB  4 fileds too. 1)ID 2) START_TIME 3) END_TIME 4)CLIENT_ID I need to select all rows from table A and Add to result rows 1 field TableB.CLIENT_ID   next rule must be used to pick CLIENT_ID for each TableA row : ...Show All

• zacarias2006 How to include SSIS into install file?

  I've already read many topics that was asked about SSIS runtime, but for my purposes I didn't find satisfied answer Our clients don't use SQL Server for their data. But we anyway used DTS packages for transfering data between client DBes. Only thing that we needed to install was DTS dlls. What will I need to do now to use old DTS and new SSIS packages on these clients In an ideal world you would have ...Show All

• SarahH Error Message when accessing Report Manager

  Whenever I try to access Report Manager, I get this message. I don't know what caused it. I recently installed Crystal Reports v11 & Oracle 10gEX evaluation apps. Could they have caused this How do I fix this Product: SQL Server Reporting Services Event ID: rsReportServerDisabled Source: Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings Version: 8.00 Message: Unable to encrypt or ...Show All

• mRW1Zard CPU to slow for SQL Server 2005 express???

  Hello, i want to install the SQL 2005 express Server on a HP-Netserver LH4 with 1 Xeon 500 CPU. I know, that i must have a 600MHz CPU, but i cant change the CPU. Is there one way to start the SQL server Thanks Michael No, the server will not bei installed, but the other parts of the program. Michael Hi Michael, Something else is going on. The processor check never issues ...Show All

• Patience404 DataSet and Insert method

  hi, i created a query to insert a row in DataSet in Visual Studio 2005. i gave the method name to the query i created. as i understood it returns '1' if successful or '0' if not. is it possible to get the ID or the row instead Hi, are you using a SQL 2k5 There is a new ouput clause in the syntax, where you can get values back. Look in the BOL for more information about that, or raise a hand if you need further assistance. HTH, Jens ...Show All

• Haowell Databound image in report header

  After finding out that SSRS doesn't directly support databound items in the header or footer, I found the workaround from Microsoft yesterday at http://msdn2.microsoft.com/en-us/library/ms159677.aspx . The problem is that their solution only works for the first page of the report, so it's basically useless! Because this is an image, it also means the workaround of using a parameter doesn't work, either. Does anybody have any advice Is there a ...Show All

• space77443 Transform data task (DTS2000) and SSIS

  My first period using SSIS in a real-world application convinced me that there is a lack of support in migration of SQL2000 DTS packages, expecially in a star schema transformation scenario. Most of my actual DTS packages are combinations of SQL Execute Task and Transform Data Task. 90% of Transform Data Task are so composed: - SELECT from Data Source - mapping from source to destination with "copy column" (source and destination columns have t ...Show All

• Jompa Best Practices Analyzer for Sql Server 2005

  Hi, Is there a version for this tool available for 2005 or do you know if new release is comming soon Regards. There is no version available yet. I haven't heard of any coming releases yet. I'm a program manager at Microsoft in SQL Server. We've decided to make a new Best Practices Analyzer tool which will support SQL Server 2005. For more information or to provide som ...Show All

• KoMas SSMS equivalent of "Poll server to find state" ?

  In SQL Management Studio, is there a way to turn off polling among the registered servers I liked this feature in SQL 2000 because it caused less network traffic, and fewer entries in the target machine's Event Viewer. I have the same question, JFoushee. Event logs are filling quickly and I'd like a way to turn off the polling like we could in Enterprise Manager. Any answers ...Show All

• Glenno How do you return query results in a streaming table-valued function?

  I am trying to write a CLR TVF that will run a query and return the results.  I am doing a CLR vs. a TSQL TVF because there will be a great deal of business logic and string manipulation in the actual TVF.  In the meantime, I am just trying to get a test one to work. Here is my class: ----------------------- Imports System Imports System.Data Imports System.Data.Sql Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Ser ...Show All