Answer Questions

• Mikhail Ryzhinskiy cannot see the 2nd table(2 tables returned from stored procedure) in dataset in report designer

  Hi, I am using stored procedure(SP) to create the dataset in report designer. My SP is returning 2 tables/recordset and i am only able to see first table/recordset in the dataset in report designer. I have to place fields from second table onto my report. Is there anyway i could get the 2nd table in my dataset so that i could place the fields in my report. Please help This is by design. We'll only look at the first resultset. Yo ...Show All

• CC Pony SSIS package configuration issue

  Gentlemen I 've been working with SSIS (SQL 2005 SP1) and I have a problem adding a package configuration of the SQL Server type. Upon completion of all steps in the wizard, the "Target Object" and "Target Property" attributes of this configuration remain empty. Hence, the package cannot set this configuration when being executed. Does anyone know if this is a bug or have I missed something Thank you Karch ...Show All

• APSrinu Accessing April CTP OLAP cube from Excel 2003

  I installed Office 2003 first on a Windows XP machine. I then installed SQL 2005 April CTP. When I try accessing cubes from Excel, I get the error "An error was encountered in the transport layer" This error occurs when I try to setup the connection to my OLAP cube. Thanks for any help you can offer Taylor I'm still having trouble with this as I still get the error. I have XML6.0 installed, OLE DB 9.0 installed but I still get the ...Show All

• Marianor Replication to IP addressed server

  we have an outside company that replicates to us and we are known to them via an IP address.   We get an error now...Sql Server 2005 now does not support a server Alias, IP address, or any other alternate name are not supports.  Specify the actual Server Name I tried putting in the hosts file on their server 168.168.110.2       SQL2005 able to connect to our server through Studio Manager...no ...Show All

• Jamzb sql server 2005 reporting service installation failed

  When I installed sql server 2005 ctp June today, the reporting services component installation failed. My computer has sql server 2000 with reporting services including all service packs. The error message is: -------- The specified Report Manager virtual directory can't be used for installation. It is already in use by another application. To proceed, enter a unique value for the virtual directory. For help, click: http://go.microsoft.com/fwli ...Show All

• Amherst HyperLink Column value is not displaying with the blue color?

  Hi all, In my Report, I am using column value with (Jump to Report)  hyperlink action, while displaying it in the report, it is not displaying with default blue color. After visiting the report or URL site, it has to change back to red color. I have checked my HTMLViewer.css file. And I have created the custom CSS file with set of HYPERLINK color combination, but it is not displaying anything at all. /ReportServer/Pages/ReportViewer.aspx ...Show All

• ripern How do i Create DataBase in SQL Server Express Edition

  I have installed SQL Server Express Edition - ( Down Loaded ) There I found only three entries such as SQL Server Configuration Manager SQL Server Error and Usage Reporting SQL Server Surface Area Configuration Express Managment tool also i down loaded and installed seperatly.. Exp.Management on start asking  ServerInstance Name and Authentication I tried with (Local) and Windows Authentication - I triend with alternative ways suc ...Show All

• xPropHead Web Synchonization Performance & Concurrent Users

  Hi I need some rough figures for replication performance. Can anyone give an idea of the number of concurrent subscribers a single IIS server can safely handle before having to move to load balancing with multiple IIS servers. I would estimate the average daily row changes to be in the region of 500 to 2500 per subscriber. Any ideas Many thanks RL highly depends on your hardware, amount of data ...Show All

• kprobst using AJAX

  Hi, For a particular application in mind I intend using AJAX to directly access a SQL procedure/ web-service preferably bypassing IIS (since it may act only as a pass-thru) using XMLhttp. Two  questions, Does SQL2005 provide access to procedures over http (I read it somewhere) w/o IIS Can I store some of my javascript logic in a BLOB and access it over http to rewrite part of a page any info will help. thanks, R ...Show All

• Todd Wilder Transform data to excel sheet or xml

  Does SQL 2005 Express have standard functionality on board to export data as an excel sheet or as XML in a specified format Can anyone help me on this Hi Mike, I am with you on the FOR XML except: (1) How do you push the results to a file I can find nothing in documentation. (2) How to connect to Database, i.e., .SQLconnection to db then use .SQLcommand I appreci ...Show All

• Clark Snowden client to client connection

  hi we have a sql 2k installed on one server and 2 clients installed with sql server 2005 express.. clients pc are winxp..is it possible to connect from one client to one client pc using the sql express thanks By default, SQL Server Express is not configured to accept remote connections, which helps reduce the risk of attack via the SQL Server service.  If you do need to access your Express server from ot ...Show All

• Cazz88 Problems when Oracle running on same machine

  I was deploying my Report Model in Visual Studio but got an error that it couldnt connect to my Report Server while it was running. When i typed the address of my ReportServer I got an error, then when I typed the name of the localhost  got an Oracle screen. So then I decided to turn off all the Oracle things running on the machine. Then when I tried to deploy again it worked and I could go to my ReportServer without problems. ...Show All

• sachin vaid Remote messages not working – message vanishes

  I need some assistance with getting service broker to work across servers.   I have 2 separate servers and I am trying to send a message from one server to the other.   No error is generated when sending the message and I get no records in the transmission queue of the sending server, however the message does not arrive on the receiving server.   Where is the message going     Here is the code I use to create ...Show All

• walterd Recursively Calling A Stored Procedure Problem

  I am writing a stored procedure that fetches the topmost value from a table, based on an ID parameter. If this value is a number the stored procedure should simply return it. If the value is an operator the stored proc needs to recursively call itself until it has two operands to use the operator on. Fairly simple logic. However I am running aground trying to get this into T-SQL. Basically I have this call in the sp: (CREATE PROC EvalFormula @b ...Show All

• Hemant K how to display sql server generated report on windows form?

  how to display sql server generated report on windows form VS 2005 contains the new ReportViewer Winforms and Webforms controls. It allows you to render a report locally or remotely (on a RS 2005 report server) and display the result directly in your Winforms application. Check http://www.gotreportviewer.com/  for more information.   -- Robert ...Show All