Answer Questions

• Tea 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

• guyinkalamazoo2 Upgrade SQL Express to SQL Server 2005

  Hi, I have VS 2005 running nicely with SQL Server Express.  I have now been asked to trial SQL Server 2005, and wondered how I go about installing it.  Do I need to replace the SQL Server Express, will it upgrade it, or can I have both up and running. Please advise on best method for a seamless installtion and experience. You have a couple of options: 1) You can upgrade your express instance. To ...Show All

• yogrraps Question about SQl Server proformance based on Datatype

  Hi all , I have a generic question about the table columns And its data type.   As per most of the sites and forums : - This is advisable that we should keep the Numeric data type (int , Bigint ,smallint ) for the columns and not char Data type to gain or boost Query performance.   Now see example below :-     Table A :         A_co ...Show All

• Jon David Import flat file automatically?

  Hi, I'm going to be getting several flat files that need to be imported into one of two tables. Although the text files will have different file names, they will have either "Header" or "Detail" in the file name, so I can tell which table they need to be imported into. The problem is I don't know enough about SQL Server 2005 to set up an automated import of these files into the database. Does anyone have any suggestions ...Show All

• rafeek footer not shown for subreports

  hi, i am showing a subreport from a main reports. i have set header and footer for the subreprt. But it is not shown. Thanks in advance, Vinu You can write the information in the body and not in the header e footer. A report can have only a footer and a body... If you found or will find a solution, please reply beacause it can help me! thanks Abc_abc How can I repeat it similar to ...Show All

• Jaime Soto Distinct Count in a new Measure Group

  Here is the situation: I have a cube that has transaction level data and there is a control number that goes with this data, but it isn't one for one.  If I have 60 million rows in the fact table, I have 50 million control numbers in a control number dimension. I would like to be able to slice the data by date (for instance) and then do a distinct count on the control number dimension.  I can do a distinct count w.o having to do ...Show All

• MSD Reporting Services and multiple data sources

  I have a group of reports that are the same for 3 different companies, the difference is the data connection. Is there a way I can change the data connection based on a variable passed in at the time of report execution thanks There are several options of how to achieve this on RS 2000 :   * Use a custom data processing extension http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_ ...Show All

• Donnie H SQLSTATE=08501 - or - Communication Link Failure

  Hello, Was just trying to solve an issue that keeps coming up periodically. We are using PowerBuilder v9.0 as our front end and MS SQL Server as our back end. We are using ODBC as opposed to using the Native SQL Server Database driver that comes with PowerBuilder. We have a process that runs hourly throughout the day, everyday, and about every two weeks we start to get strange errors coming from this process. Most notably, the following error me ...Show All

• Giampaolo Why I cant not deploy my project?

  Hi, all here, I am currently encountering a problem when I try to deploy my project. The error always occur with message like this: The dimension with ID of 'Country Region', Name of 'Country Region' referenced by the '539F3D4D-93E0-4D4D-A3A5-4E2C2872D9C4 ~MC' cube, does not exist. Errors in the metadata manager. An error occurred when loading the 539F3D4D-93E0-4D4D-A3A5-4E2C2872D9C4 ~MC cube, from the file, '\\ \C:\Program Files\Microsoft SQ ...Show All

• ptalindstrom Configurations

  I have read many posts about configurations. However, in practice, I cannot solve a problem that is bothering me. I have connection managers (that manage SQL Server 2005 connections) configured in a local package. I have ProtectionLevel = 1 (By the way, where do you state that you want it "DontSaveSensitive", etc ). When I deploy the package to another computer (using the deployment utility) though, I get the error "The AcquireCon ...Show All

• dkfitzgerald URGENT! - - Unable to connect to SQL 2005 Server

  Hello, I have a SQL 2005 Developer edition server, its freshly installed. I am unable to connect up to the server using the server IP. I just get a error message, when I do a port scan on the machine, it shows port 1433 is closed. I have gone into the SQL server configuration manager, and the TCP/IP port is enabled. I dont have firewall enabled on my windows XP pro SP2 machine , nor do I have any anti virus programs on this machine. ...Show All

• vatsal shah Newbie - Querying SQL Server Express 2005 database from Excel

  Sorry if this is a stupid question, but I created a database using SQl Server Express 2005 and I would like to query one of its tables from an Excel spreadsheet. Here's what I want to do in pseudo code. cell A2.value = select OLIGO_ID from table OLIGO where SEQUENCE = 'content of cell D2, a string' In other words, I want to search the database for a string that is in a cell and retrieve its associated ID number into another cell. I need ...Show All

• dr.pavan URGENT! - - Unable to connect to SQL 2005 Server

  Hello, I have a SQL 2005 Developer edition server, its freshly installed. I am unable to connect up to the server using the server IP. I just get a error message, when I do a port scan on the machine, it shows port 1433 is closed. I have gone into the SQL server configuration manager, and the TCP/IP port is enabled. I dont have firewall enabled on my windows XP pro SP2 machine , nor do I have any anti virus programs on this machine. ...Show All

• DanLeg problems during the deployment phase

  I used the Business Intelligence Studio to make a report. I also enabled the tcp/ip protocol but during the deployment of the report i get the following error. I can see the report in Preview-Layout mode but i can t run the project. Could you help me Thanks In Advance =================================== A connection could not be made to the report server http://localhost/ReportServer$DVLP002_SQL2005/Reports . (Microsoft Report Desi ...Show All

• Jin RS 2000 installation issue.(err : Can not generate SSPI Context)

  Hi I am trying to install RS 2000 on my machine. I have SQL server 2000 client. I am connecting to remote database server. When it asks for the server instance credential I am giving the right one. It is asking for three type of credentials 1- Service account 2- Domain login Account 3- SQL login account. It is failing in all the cases. Is there any fix for this. Thanx in advance. ...Show All