Answer Questions

• Frances83 Books Online

  I have registered to use SQL server 2005 Express Edition.  I want to download relevant documentation for books online. The guidance for this is to download the 'SqlServer2k5_BOL_Jul2006.msi' software. When I initiate this download:- (1) I get a message from my ISP (I.e AOL) saying the publisher coud not be verified, and asking if I wanted to run this software. (2) when I press 'run' software is downloaded to a tmp file, and I get the option to install. (3) On clicking the install button, a Windiws Installer message appears - this states that ' the installation package cannot be opened and suggests contacting the application vendor to verify that this is a valid Windows Installer Package. How can I  access the ...Show All

• JonEbersole Excel Pop-up

  Hi, In a particular report, i've got the following pop-up when opening the excel export: http://img515.imageshack.us/img515/9868/xlerror5ye.jpg (translation from french: "Name already used - Name can't be identical to a predefined name"). It seems that there is a problem with names generated automatically for cells references. When I suppress report's header, the pop-up doesn't appear. Any explanation for this behaviour Thanks in advance. Gregory. I have the same problem !! ...Show All

• Helen999888 Something like a SQL Union in MDX?

  I'm slowly getting my head wrapped around MDX, but I haven't absorbed enough yet to even speculate whether this is possible: I'm looking for something like a SQL Union, but in an MDX query. Basically, I've got a whole family of queries that each produce similar-shaped results (same number of dimensions, same data types, but different underlying cube dimensions). I'd like to combine those results together (i.e. project all of the coordinate spaces into a single unified space via a mapping of dimensions - just like a SQL union does). The reason for combining them together: I need to sort the whole composite list and choose the Top few. Is there a general approach to getting UNION like behavior in MDX I can post more details about t ...Show All

• Kary178332 Maxis 3G connection

  I cannot connect to SQL Server 2000(Remote Server) through Maxis 3G connection. I'm using Windows Application to connect to SQL Server 2000. dim strsqlcon as string = "Server=000.000.000.000;databse=dbname;usr=sa;pws=1234" dim sqlcon as sqlconnection = new sqlconnection(strsqlcon) sqlcon.open() "It's Error : Sql not exist or access denied." But I can connect to SQL Server 2000(Remote Server) through Local Area Connection. Have any solution Thank you. I didnt install any firewall on my Server. If firewall is blocking, how do i set it off You need to talk to you network administrato ...Show All

• yqiang Calculated field crashes VS

  I had a separate post where I was having trouble displaying the entire record in the group header that was that had the max value for the details. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=641646&SiteID=1 With some help, I used a nested table in the group header, which worked perfectly except when I export the report to Excel (end user requirement) those values are replaced with ''Data Regions within table/matrix cells are ignored.'' For a workaround, I tried adding the following expression to a text box in the detail row of the table. =iif(Fields!MAX.Value = max(Fields!MAX.Value), Fields!ASA.Value * 100, Fields!ASA.Value) This will check the max value against the max for the group. If the max value is truely ...Show All

• NetPochi Running job error in schedule

  Dear All, I set the scheduler to run a stored procedure and it casyes error. Failed to run the stored procedure but when running it manually from the query analyser it works just fine. This is the error. SQL Server Scheduled Job “Job ABC” (0xE708F39963C95A4390BC3C99E6A029AC) – Status: Failed – Invoked on 2006-12-10 03:00:00 – Message: The job failed. The job was invoked by Schedule 7. Could anyone please advise what should be the problem Regards, LG Dear rottengeek, I have found that there is no that check box saying show step details. Please advise if you have any further instructions. Regards, LG If it works o ...Show All

• franziss Deploying Reports/Models with WSS 3.0 integrated mode

  Using BIDS, and trying to deploy to a newly created reporting server. I can deploy the report but cannot figure out how to display it in the WSS 3.0 teamsite. My document library settings allow 'new report builder report' and 'new report datasource' but I don't see how to upload reports built in BIDS for use in the Sharepoint site. Models that I created in BIDS I cannot deploy at all. Just get an error saying 'this operation is not supported in sharepoint integrated mode. Anyone else worked through the deployment of existing datasources and reports yet to a WSS 3.0 reporting server in integrated mode If I just upload an RDL file to the document library and try to display it, I get the following: System.Web.Services.Protocols.So ...Show All

• Nishant Sivakumar how can i get this query

  Hi can anybody give me a suggestion to get result like Student Computer Geography Social ID Name ID SEM Marks ID SEM Marks ID SEM Marks 1 ABC 1 1 80 1 2 35 1 3 88 2 CDE 2 1 60 3 2 65 2 3 45 3 XYZ 2 2 55 3 1 67 3 1 75 and I want OUTPUT as below Name Com ...Show All

• Montana Jones Secure Microsoft Access to SQL Linked Tables

  Not sure if I'm posting to the right group or not, pls tell me where else to post. My question is: I have a microsoft access database on a client desktop that links to tables in sql server. Is there a way to encrypt the data that goes back and forth between access and sql You can set the appropriate property for this in your connection string. Take a look at http://msdn2.microsoft.com/en-us/library/ms130822.aspx for some additional information. ...Show All

• Jakein2006 selectively receiving

  I have a scenario whereby I will have 200+ clients putting messages onto a service broker queue. This message will go through a pipes and filters based messaging system, and ultimately the message will pop out the other end. Here's the question: what is a good way of making sure the same client gets the response to the message he received. Is there anyway I can selectively receive messages from a queue, i.e., pass a correlation id in with the message, and then filter messages based on that id. Or if someone knows a better way to do it altogether i'd really appreciate it. Many thanks, Paul Hi There Does each client have a different initiator service name ...Show All

• Søren Mondrup SQL Time Out Problem

  Hi All, we have got a serious problem in our production environment with SQL server. We are using vb.net as a front end. and its a windows service.It keep on polling for the data in one DB server. And if the items are ready(identified by some flag), it will be exported to another server. But its workin fine with the small volume data.We have tested this with the huge volume data. And everytime it throws an error "Sql server timeout expired". Even if there is no items to export. it causes the problem during the search for the flag with this high volume data. And we are mostly using dynamic sql in our SPs.. can someone please suggest me how can i debug and troubleshoot the problem.. Thanks, your help is appreciated! ...Show All

• James_Steven Find SQL Server 2005

  Hello, My problem is this: In the phase of installation of my software, how I can know if SQL Server 2005 (anyone edition) is installed in the guest system Thank you. If you use Visual Studio for building installer, you could add "Windows Installer Search" at Launch Conditions page. But you need to know ComponentIDs for SQL Server. I think, that this link would be helpful http://msdn2.microsoft.com/en-us/library/1s08hzfe(vs.80).aspx You could scan LAN vid SqlDataSourceEnumerator. using System.Data.Sql; class Program { static void Main() { // Retrieve the enumerator instance and then the data. SqlDataSourceEnumerator instance = S ...Show All

• crino Table creation scripts for a faster reply to your questions.

  Hi all, As per suggestion from Louis: For a faster reply to your questions please provide the team with the table generation script and the insert scripts needed to generate sample data. example: table generation scripts: Create table #temp ( column_a  int identity(1,1), column_b varchar(20) ) insert scripts insert  #temp(column_b) values('xx') insert  #temp(column_b) values('yy') insert  #temp(column_b) values('zzz') My question: I want to sort my data in descending order   thanks, Joey ...Show All

• TBing how do i compare data in 2 different tables using objrs?????

  Hey all, got abit of a problem. Ive got a database where ive got 2 tables. I want to create a command which selects * from table 1 and if the same values are in table2 - it updates otherwise adds.  Ive got a loop so i can run through the data records But i dont know how i check 1 objrs against another within an sql statement   please look at coding example below: Im calling my data from the 2 tables using select commands- which is ok.- uses objrs1 and objrs2 Then im running my loop to check if data from table 1 is in table2: Dim Q For J = 1 to iRowCount2  Q= Q+1 Call select2Cmd( )   response.write(Q)   response.write("</br>")  Next  response.end    Heres my sql statement ...Show All

• Bishnupada Mukhopadhyay Grouping by Age

  I have a table Age and need to create Report by Grouping Salesfigures according to Age. I put the following expression into Grouping and Sorting Properties/General/Filter /Sorting Expression... as well as in Textbox Properties/ values.. =IIF(Fields!Age.Value < 16, "<16",IIF(Fields!Age.Value <21,"16-20") Errormessage: Value expression for textbox "Age" error: Argument not specified for parameter 'FalsePart' of 'Public function IIF(Expression as Boolean, TruePart as Object, Falsepart As Object) As Object'. Question 2 . How to return Month as January, February... In correct order "DATENAME(mm, Sales.time) AS Month" (Ascending ) returns starting with April, August... DATEPART(mm, Sales.time) AS ...Show All