Answer Questions

• AlexBB Predicate Vs Residual Predicate

  hi , what is the definition and difference between predicate and residual predicate. give me some examples..Basically the columns used in where clause are called as predicates. Am i right. I hope Craig Freedman's   Blog may help full for you http://blogs.msdn.com/craigfr/archive/2006/07/07/652668.aspx ...Show All

• p_shah Can get RDL file name?

  Hi, Is any way can get RDL file name and show on text box Any function or something else Thanks for any advices! The ReportObjectModel exposed to RDL expressions contains several collections (see also: http://msdn2.microsoft.com/en-us/library/ms157274.aspx ). One of them is the Globals collections: Member Type Description ExecutionTime DateTime The date and time that the report began to run. PageNumber Integer The current page number. Can be used only in page header and footer. ReportFolder String The full path to the folder containing the report. This does not include the report server URL. ReportName String ...Show All

• Steve98796 Bug in Task

  Hi all, I have a job that run 3 task. The first one do a backup, the second one copy those backup files from one drive to another drive, the third one supposed to delete the backup from the first drive. What is happening is as soon as the second task start the third task also start for some reason, it does not wait for all the backup files to be moved, so i end up with one backup file being copied on the second drive (locking the backup file) but all the other backup get deleted except for the lock file. Has anyone encounter the same problem is there a way i can set up the third task not to start until the second is completed the tasks are link by the green arrow I fou ...Show All

• Petknep SQL 2005 Disaster Recovery Guide

  Hi All, Does somebody know where can I find a guide or white paper regarding to the subject It should contain the procedures needed to recover Analisys, Reporting and Integration services as well. Thanks, Miska http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1223049,00.html http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/07/621060.aspx I believe there is no documentation or information available for AS, RS & SSIS in this regard, you need refer to books online whether such information is provided or a high-level task to follow on. ...Show All

• Brian OByrne how to group ?

  Hi, How to display the table in the below format Table1 City Customer AMount Chennai Raja 5000 Delhi Ravi 2000 Bombay Jambu 4500 Chennai Raghu 1500 Bombay Siva 2000 Delhi Jas 5000 OUtput Chennai Customer Amount Raja 5000 Raghu 1500 Delhi Customer Amount Ravi 2000 jas 5000 Bombay Customer Amount Jambu 4500 Siva 2000 HOw to do that As Chris indicated, SQL Server is about storing and retreiving data -NOT about display. What you are attempting is best accomplished in a client tool -such as Reporting Services. This is certainly possible in SQL, but the formatting of data in such a manner isn't really what SQL Se ...Show All

• Roach SSIS and the Receive Command

  I built a system where I am sending batches of messages using a single conversation. I want to pull these messages out of my queue using Service Broker. I may have more than one batch sitting in the queue waiting to be picked up, so.... In my SSIS package i started by getting a unique list of conversation_handles where the message type is my end of batch message ( should only be one per batch). Then I used the foreach loop construct thinking I could pass the conversation_handles around and into the data flow. In the data flow I want to pull all of the messages at once. It looks like the receive statement is designed to do this with the concept of using a table variable. So I built this SQL to use in for the SQL Command of my OLE ...Show All

• Esprit Understanding cube

  Hi, I am new to OLAP and was reading on this area on the web. I come across this statement like: "while the relational database (OLTP) updates...the OLAP database will not be updated. " I am not sure of the above statment. In that case the data in OLAP is not the latest and how is it going to be updated Thanks. Regards Alu The OLAP database(Analysis services 2000/2005) is a separate engine and structure from the relational data warehouse or OLTP system. But every time you process an OLAP cube it will update with new records from the data source. There is an exception to this with a possibility to update cubes very close to immediate time. Normally you will update a cube the day after an OLTP-system. ...Show All

• Robin E Davies ways of transferring database between two different servers

  hello friends, I need to transfer my database from one server to database on another server every 24 hours. I can create windows application but it will be cumbersome to write bulk of code . So can u suggest me some service or any other way through query or stored procedure or by job scheduling which can run every 24 hours and move my data from one database on one server to another sql database. Both database systems are sql server 2000 but servers are diffeerent so how to connect them while transferring dbs. Any help is appreciated. regards, max If you are using SQL 2000 (enterprise edition) then you can take help of Log shipping in this case, if not that edition then you can define a maintenance plan to backp the transaction log ...Show All

• jshepler Help me Deploying rdl Report

  Hi I am new to SQL Reporting Services. I have developed an rdl report in SQL Server Reporting Serices 2005. It works very fine in development environment. But now i want to include this report in an exisitng project running at our client in some remote location. This report 'll be accessed by several clients from different offices. To view reports locally I have added myself as an administrator on the local Report Server. But how would i authecticate specific users that i want to grant access to the report. I have a database table that stores users that have access to that report. Also how do I upload these reports with all these users settings on the client's Report Server. Looking forward for ur good response. Regards ...Show All

• Mateusz Rajca Issue with the SUM function, Need Help

  I need to add the SUM function or find a way in SRS to display certain members of my query (below) that have a combined total credit score of 5.0 or higher. For example, I run a report that shows a person's earned CEUs, if all of there CEUs total 5.0 or higher, I need to display there information. I have tried using SUM(CEUs) as Total but it just adds each CEU line twice. I need to get a total for each person's CEUs and then only display them if the number is above 5.0. Thank you, DECLARE @from datetime, @to datetime SET @from = CONVERT(varchar(11), @MinDate, 1) SET @to = CONVERT(varchar(11), @Maxdate, 1) SELECT EducationCreditHistory.ContactID, EducationCreditHistory.CourseID, contactbase.FirstName, contac ...Show All

• cipcip Error in Processing Cubes SSAS2005

  I am trying to deploy and process cubes to production server, i got this error with processing failure Errors in the back-end database access module. OLE DB reported the '' status, which is unknown, for column 1. So deployment works fine. I have deployed and processed and the same cube to Development and Test server, it goes through pretty well without any errors. Any one has an idea what this error means Thanks This error means Analysis Server for some reason couldn’t instantiate OLEDB provider to connect to relational database. Several reasons: 1. For some reason your production sever cannot access relational database. Check Analysis Server service account. Does it have privileges to access relational dat ...Show All

• Vladimir Bougay Using report server project to generate graphs

  Hi there, Can someone help me with how to create a bar chart using report server project in Visual Studio 2005 I have successfully created a report using a query. What do I need to do after this to generate a bar chart Any helpful link/hints would be nice :) Thanks in advance Thanks for the link... I used the webcasts to help me in creating various charts in Reporting Services as I moved from using Crystal Reports to RS recently. This link should take you to various webcasts that might help: http://www.microsoft.com/events/series/msdnsqlserver2005.mspx#BusinessIntelligenceandReportingServices ...Show All

• Arcan Errors using the uninstall tool - 'vs_uninst_betas'

  Hi Folks getting the following error message when using the tool and can get past it. i can email the error dialog to you if required, i just cant post it. the setup has encountered an unexpected error in data store. The action is RestoreSetupParams. The error is: Failed to read property installl ds What are you trying to uninstall This tool was written by VS, it might be valueable to post this question into one of the VS forums. Mike I don't think the definitive article exists on backup for Express, we pretty much default to "just use Windows Task Scheduler" like that really helps. That said, I've found a few interesting bits to suffice untill I finally write the definitive a ...Show All

• Robb Melancon Service Broker and routing

  Hi We are currently starting new project and evaluating possibility of using Service Broker in it but seems there could be some problems We have a central server with a central database and several hundred of “mobile” users. Information ( actually a subset which is specific to a particular user ) should be sent from/to central database and we wanted to use Service Broker for this. When you set up a route in Service Broker you need to define Network address which I believe should be an IP address or DNS name. The problem for us is that our “mobile” users do not have static IP addresses and I am not sure we can assign a unique dns to all of them. Mobile users can connect to internet in different places… and hence get ...Show All

• JohnACE Data type problem

  Greetings SSIS friends, I cast one of my fields from a decimal to an int in my data source (generated from a SQL command). But when I try and map that field to another one of my tables, i get an error saying that I can not cvonvert from decimal to Int32. Is there any solution which doest require using the derived column or data conversion components ! Your help would be appreciated. Did you previously have the decimal coming into the source and then later changed the SQL to cast it to an integer In the source column mappings, delete the row that corresponds to the column you are working with, and re-map it. Does that help Hi Phil, Yes you are right. I unmapped the column and then remaped it and reconfigur ...Show All