Answer Questions

• Dennis Kriek Microsoft reporting Services Support & Changes

  Hi We are planning to install the Reporting Services, but have been given a very negative feedback by some companies which planned to move to this. The type of uncertainities that are coming through are: 1) product may either undergo a signifcant change 2) lose support Can anyone help me with these questions, as i myself believe that it is hard to imagine such a big change. Let me know what you think about this Thanking you in anticip ...Show All

• Sebastien Ros Function that returns a table

  I have a function that returns a single row table with two columns: dbo.Fun1(@param1) :  colA and colB I tried to create a stored procedure that use this function: select col1, col2, dbo.Fun1(col1) from table1   The result is : Invalid object name 'dbo.Fun1' There is no join between table1 and Fun1, how can I select  the both columns of Fun1   Thanks in advance. Long     ...Show All

• ToMoGroup Querying AS 2000 Cubes from SQLServer 2000

  When creating a linked server from SQLServer 2000 to query data from AS 2000 cubes, I get an error: Here's the command I used to create the linked server in SQL Server 2000: EXEC sp_addlinkedserver @server='OLAP', @srvproduct='', @provider='MSOLAP', @datasrc='ServerABC', @catalog='OLAP_DB' go and then when I run the following query: SELECT * FROM OPENQUERY( OLAP, 'SELECT [Seg ...Show All

• Rohan_Misys Background image sizing

  Hello, I have a jpg image to use as report background. How can I strecth the image in order to fill the page background (i'm using PDF output) with my image Thanks, Pierre Hi Robert, ok, hoping for the next release :-) Thanks, Pierre Hello Robert, thanks for the reply. I already Tryied these settings but I can't stretch the background image, just set the repeating style. Since the report must be rendered as PDF only, how can I ...Show All

• Javier Aranda Pantoja RS 2005 - Evaluation Version

  Our RS 2005 - Evaluation Version has expired  .... does anyone know if it is possible to copy existing RS reports from an evaluation server to another server How is this done Thanks. RS 2005 is already installed on the new server.   You can use the reporting services configuration tool to configure the new report server to use the existing report server database. Connect the configuration tool to the report server, then u ...Show All

• phil_johnson38 Script component as Destination - HasSideEffects?

  How to set 'HasSideEffects' property for any input column of a script component used as destination My Script component reads input, generates SQL update statements dynamically and fires them. There is no output. When executing, I get this error (which is self-explanatory). "Script Component" (1573) has been removed from the Data Flow task because its output is not used and its inputs have no side effects. If the component is required, then t ...Show All

• Jesper Persson Unable to create linked server on 64 bit SQL 2005

  We have just started migrating our SQL Database to a new 64 bit server. The problem is that we must import data from text files (some are fixed width other CSV) and there is no Jet 4.0 OLEDB provider installed on the machine. In the past we have created a linked server to import the data. When I try to download the Win 2003 version of Jet, I get the error “wrong hardware”. Were do I get a 64 bit version of Jet or is there a way to insta ...Show All

• pato135 SSIS Fuzzy Matching

  Is there any way to use fuzzy lookup functionality (that exists in SSIS) in your .Net code   I want to call a .Net class rather than calling an SSIS package. Thank you. -- AK Thank you  Michel, Jamie, and Darren for clarifying the issue. Yes, as Jamie wrote, the startup time for a SSIS package is quite significant.  I have a project with a relatively big database (3+ million records), and needed to do fuzzy matchi ...Show All

• Praveen Chintala Visual Basic application return connection timed out

  We are using SQL Server 2000 in my company. My software development team has developed an application. We encouter problem whereby sometime all the clients' application return connection timed out. We have wireless client as well as wired client. But, the problem occurs the wired client also faced the same problem. We checked the sqlserver task manager when the problem occured but found that CPU and RAM usage are normal. CPU is around 40% ...Show All

• Agent_ VS2005 & BI Calculations Tab

  After installing MSSQL 2005 SP1 I now have a problem in my BI Projects. Whever I open a cube in the designer and select the Calculations Tab, the mouse becomes an infinite hour glass as well as the words "loading..." in the center screen. I have forcefully terminate the IDE. Has anyone come across this behavior and found a fix for a similar problem Thanks, -Troy I'm moving this qu ...Show All

• hanbert Can't uninstall Reporting Services

  I need to reinstall Reporting Services but during uninstall I face the following error: "The setup failed to read IIsMimeMap table. The error code is -2147024893" Nothing seems to help with the problem. Regards, Ksenia I ran into the same problem. Based on KDog's suggestion, I stopped IIS before running the uninstall. That seemed to do the trick as well. There is no need to uni ...Show All

• Murdoch Previous Row Calculations (sql server 2000)

   if anyone know a way that you can look up a value from the previous row in a View to do a calculation on (in sql server 2000) for example: expr1=PreviousRow.Expr1/30 + expr2 - expr3 =100 so the next row is expr1=100/30 + expr2 - expr3 =300 so the third row is expr1=300/30 + expr2 - expr3 =100 or tell me if it not possible please and special thanks to Umachandar Jayachandran - MS for help. sweet. ...Show All

• Hugh Burton SQL Server 2005 Reporting Serivces: XML Datasource problem

  Hi, I'm just starting to use SQL Server 2005 Reporting services, and need to use an XMLdocument as the datasource. I will get the xml data from a webservice and then need to bind it to the report. Here is what I am doing: 1. I created a webservice at the following location: http://localhost/myWebDirectory/myService.asmx . this webservice has a method called " GetXMLDocument" that has 1 parameter (sql). This method uses the sql st ...Show All

• JimboGT Error updating data in table that uses a trigger?

  Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error: ------- The data in row 1 was not committed. Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) update ...Show All

• Jonalyn Alerts

  Hi everyone, I also could not find any definition about Alerts and their purpose and usage. Would you please explain it to me Thanks Did you read all about alerts There are 28 subtopics under 'alerts' in 2000 BOL, some with even more subtopics... But very short, yes you got it right, the purpose of alerts is that you use them in order to create an automated 'alarm-function' that will be triggered by something and then do some actio ...Show All