Answer Questions

• bbJosh Transactional Push Distribution Agent Slow

  We have quite a lot of Transactional replication, and over the past few weeks it had become quite slow. I spent the last few days trying to resolve the problem and found that a Push subscription was delivering transactions at about 50/sec and a Pull subscription was delivering at around 700/sec. This test was run on the Same publication, same subscriber so hardware and links are all the same, the only difference was the type of subscription. I've since changed a few of our subscriptions for the larger publications and have found they run quicker than previously. Has anyone else seen this behavour and is there a valid reason why this would occur. The distributor and subscriber are both running SQL2005 SP1 and the publisher is SQL2000 ...Show All

• Walker Boh problem with drilldown (ReportServer)

  hi, i have a problem with the drilldown functionality of my report: in the preview pane in VS2005 everything works fine but when I try to execute the report on reportserver the only thing I see is the top level and I'm not able to drilldown into lower levels ... anyone has an idea I did not implement the drilldown in mdx statement but used grouping & toggle item in VS2005. could that be the reason thanks, rhpasy Check the supported versions for different web browsers. Static reports is the version supported in older browsers. Also add the reportserver/manager to the local intranet zone or trusted site(if you use Internet Explorer). Regards Thomas Ivarsson ...Show All

• Mutola Combining multiple data sources (sql & oracle) into a single report

  I'm trying to find a way to pull data from an Oracle data source and a SQL Server data source into a single report. We've got data located in each DB and I want to present the data in a single report. Any ideas on how to best do this (if at all possible) Thanks! Derek ...Show All

• Wen Jin-Chao Applying SSIS in Application

  Is there anyway I can integrate the ssis in Web applications or Windows applications Thanks Yes. There are API's available that allow you to execute packages programatically and also to consume data from them (which is a very cool feature). These APIs allow the sort of integration that you're probably after. This is a good place to start: Integration Services Developer InfoCenter ( http://msdn2.microsoft.com/en-us/library/ms137709.aspx ) -Jamie ...Show All

• Jamie Thomson error when processing cubes just migrated from 2000 to 2005

  im in the process of testing how to upgrade from analysis server 2000 to analysis server 2005. i have migrated my cubes to a test 2005 server and created a project out of them. when i try to deploy this project i get these two errors: Error 1 OLE DB error: OLE DB or ODBC error: The multi-part identifier "PrintDimensionTransactionDate.TransactionDate" could not be bound.; 42000. 0 0 Error 2 Errors in the OLAP storage engine: An error occurred while processing the 'Print' partition of the 'Print' measure group for the 'Print' cube from the testSRDBProj database. 0 0 these cubes worked fine before i migrated them. does anyone know what could be going wrong ye ...Show All

• XiMDeb select values from multi-value parameter

  Is it possible to pass values from UI to a multi-value parameter in a report and from this report, select values from this multi-value parameter to finally display data Thanks! Follow up question please. When I get values for a multi-value parameter from SP, values are displayed with checkbox on their leftside, thus, allowing me to select from values. But when I supply values from UI using ReportParameter[] class, values displayed in report do not have checkbox beside them, and thus, not allowing me to select from those. I'd like to display values with checkbox please. Thank you. Hi CandyMe, Have you got the checkbox now I encounter the same problem an ...Show All

• arkiboys using a text editor to open a SQL Database

  is there some way to access a corrupted database with a text editor so that I can copy over my text database to a new database file I apparently have corrupted my file headers of both the online database and my backup copy. Thanks in advance for your help Well, if ASP.NET isn't hoppin' we'll try to solve the issue here. It will help me if I know where you're actually trying to add users. Are you talking about the web console that you launch from Visual Studio If so, what version of Visual Studio are you using Thanks for the clarification. Mike SQL Express doesn't have a web admin tool or internet interface. It looks like you're actually having problems with the ASP.NET membership databas ...Show All

• HCTwinJava MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

  Hi, I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005. The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed. This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material. No books are published yet. Does anyone have any good ideas on where to find 'good' samples and tutorials meant for a person who is studying for the new Microsoft SQL Server 2005 Database Administrator Exam MCTS 70-431 All answers and ideas in 'any form' are appreciated. Thank you very much. ...Show All

• Mantorok The product dimension is not updated. Anybody can help?

  Hello I have a strange issue with an AS2005 database. I have my product table on the Sql 2005 db with 61000 records. I should have the same number of records in my product dimension on AS2005 instead I have 54000 and so I have a lot of unknown records in my AS database. It seems that the system is unable to load all the data. Any suggestion Thank you! Andrea It shows 54000. I start to think that the problem might be in SQL table and not in the AS. I am going to check the primary key and indexes in the main tables. Thank you If you run the aggregation design wizard, does it show 54 000 or 61 000 Regards Thomas Ivarsson ...Show All

• Parker Lewis Hierarchal data reports

  I have set up a hierarchal report, which is based on one data set using a table and grouping. I have a group header, a details, and a group footer section in the table. The details is filtered based on one of the columns, and hidden with the ability for the user to expand and collapse the row based on one of the fields in the group header. My problem is, I am trying to set up a report which gets scheduled to run weekly, and emailed out to its users, in PDF format. The PDF format will not allow the user to expand and collapse the rows. I would just send the users a link to the report, and the can expand / collapse the rows they want to see, if they didn't mind having to be connected to set up their report, and having the extra step of expor ...Show All

• JamesMitchell still not correct - Reporting services syntax

  hi there RS2005 - Layout tab I have a field that says txtTrackerTrue=Sum(Iif ((Fields!Tracker.Value = Fields!RecvdBy.Value), 1,0 )) I want another field that says txtAllTrue =Sum(Iif ((Fields!Tracker.Value, ClosedBy.Value = Fields!RecvdBy, 1,0 )) obviously this is going to error how would I do this please thanks Jens suggested that you do the same thing, but Jens did not mention that you need to use the .Value property. Make sure that the .Value property is used on the ReportItem, otherwise you will get the this error. Ian hey there thanks for jumping in, Reading back I didn't explain myself very well at all - sorry about that RS2005 - layout tab Name of txt box = ...Show All

• kampak1111 Date out of range?!

  Greetings! I have a data source that gets generated based on a variable with the following SQL : "select * from result where deletion_ind = 1 and when_deleted >= '" + (dt_str, 50, 1252) @[User::Last_Run_Date] + "'" But when I run my package I get an error message saying: The conversion of CHAR to DATETIME resulted in a DATETIME value out of range The Last_Run_Date variable is set to '2006-06-25 14:35:05.450' When I run the code in a QA session it works, but in the package it complains! What am I doing wrong Thanks for your help in advance. Does the error get thrown by SSIS eval;uating the expression or by SQL Server when it gets executed The expression evalua ...Show All

• ThEpRoPhEcY373 Visual Studio with Analysis Services Solution Hangs

  I have an existing project that was fine before... now when I click on the "Calculations" tab it says "Loading..." and never loads. This also happens on the "Perspectives" tab. I tried uninstalling and reinstalling VS... reinstalling the BIDS projects... HELP! Sounds like there is something in your MDX Script that BIDS cannot parse. Try the following, making sure to backup your entire solution first! make a backup copy of the .cube file of the cube in question open up the .cube file in a notepad or some other editor delete all the text between the <Command></Command> tags under <Cube><MDXScripts><MDXScript><Commands> (it will be down near the end of the fi ...Show All

• InquiringMinds File System Task Error

  Hi, I am using the 'File System Task ' to create a directory structure (e.g ..\DB; ..\DB\LOG; ..\DB\BACKUP; ) I set following properties for the single tasks: UseDirectoryIfExists = True;  Operation = Create Directory; The task works fine before installing SP1 on the server.  Now it creates an ERROR if the directory already exists and it is not empty. SSIS package "testcreatedirectory.dtsx" starting. Warning: 0xC002915A at Create DB Directory, File System Task: The Directory already exists. Error: 0xC002F304 at Create DB Directory, File System Task: An error occurred with the following error message: "Das Verzeichnis ist nicht leer.". (The Directory is not empty.) Task failed: Create DB Directory ...Show All

• doank KB918222 Windows 2003x64 R2 fails

  When I try to apply this post SP1 patch to SQL Server 2005 x 64 on a Windows 2003x64 R2 system it fails everytime. The following is the HOTFIX log: 07/12/2006 15:02:06.781 ================================================================================ 07/12/2006 15:02:06.781 Hotfix package launched 07/12/2006 15:02:08.046 Product discovery successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 SP Level check successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 Product language check successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 Product version check successfully completed during the install process for MSSQLSERVER 07/12/2 ...Show All