Answer Questions

• tropics43 Which expression is better?

  I am in the process of re-writing 30 existing reports. My question is which syntax is more effecient or better =Sum (Fields!Amount.Value, "DataSet")/100 or =Sum (Fields!Amount.Value/100, "DataSet") Thanks! This is the slightly more efficient way of doing it: =Sum(Fields!Amount.Value, "DataSet") / 100 Divisions are generally more expensive than adding items. By dividing only once the overall expression is more efficient. But dep ...Show All

• Zach Griswold Determining Trigger Order

  I'm not sure if this is the correct forum or not for this question. Basically, i have 6 triggers attached to my table (2 of each type). I used sp_settriggerorder to make sure certian triggers fire first. Is there any way to go back and determine what order a trigger has been set to (first, none or last) I've scanned through all of the system tables and don't see anything. Thanks in advance. With some digging, you can find that they encod ...Show All

• NoSuchThingAs2 Relational to DataWarehouse?

  Can somebody please guide me in how to convert a relational database to a datawarehouse . Thanks Start with a good book (say,Ralph Kimball's  The Data Warehouse Lifecycle Toolkit : Expert Methods for Designing, Developing, and Deploying Data Warehouses ) to understand "how-to" and then read tutorials/samples from BOL. I think your question is a bit too specific. Please could you be a bit more vague (!!!) -Jamie ...Show All

• Moritz Kroll Reporting Services Version Question

  I'm afraid I know the answer to this already, but I just have to ask.  If I am using SQL 2000 Standard Edition, can I run the Enterprise edition of Reporting Services If you are running them on the same box (covered by a single license), then you need to run the same edition. If you are running them on different machines (which requires a second license), then you can mix versions. ...Show All

• HectorC SQL Server 2005 Remote Connection Problem... Big Time.

  Hi, I installed SQL server 2005 express edition on my windows server and I had no problem with connecting it remotely through Management Studio, then I removed it and installed a full edition SQL server 2005. That's when it's gone all wrong. Now I can't remotely connect the server through Management Studio. The error I get is the same as some of the people in this forum has which is: "An error has occurred while establishing a conn ...Show All

• Rose Pause between pages when printing RS report

  I am using Report Services on SQL Server 2005. I have a report that gets its data from a single SQL Server stored procedure. One other small table is used, but only to provide a list of values for selecting a parameter value to send to the stored procedure. On the report I use a list control to display multiple records per page. When printing the report (which currently produces over 500 pages - future printings of this report will not be nearly ...Show All

• aak165842 sql server 2005 books online

  where is the import and export data function in sql server 2005 express i have a data in ms access which i want to import to sql server 2005 express.. thank you I have used DTC that came with SQL2000 that our company uses, if you don't have SQL2000 you could download the Trial edition and just install the SQL Client Tools which don't expire after the trial time period.  This might raise some kin ...Show All

• Jeff Levinson cannot install SQL Server Express, keep getting errors

  I am trying to install SQL Server 2005 Express, but it fails. SQL Server Setup has detected incompatible components from Beta version of Visual Studio, .NETFramework or SQL Server 2005. Use Add or Remove to I had earlier installed Beta 2 Version of Dev Studio 2005 and SQL Server 2005 Beta 2. I also had DevStudio 2003 and SQL Server installed. I have gone through and un-installed everything, but I keep getting this error. I have also tried msiexe ...Show All

• Oopier using filters to full text search inside pdf & word documents

  how can pdf, word filters be used to full text search inside pdf, word documents using SQl Server 2005 and how to find what filters are loaded. please give a step by step instruction or direct to a comprehensive tutorial. thanks for reading. clearly no one has an expert advice for using filters to full text search inside pdf & word documents. someone please point me to a forum or another site where i can get information in this to ...Show All

• danjam SSIS delta

  Hi , i'm new to this platform and am wondering if there is an easy way to identify ADDs changes and deletes between two tables - or whether i will have to do a ror for row comparison using the business key Any suggestions would be greatly appreciated.. thank you George Bassili George, This may be of help to you: http://www.sqlis.com/default.aspx 311 -Jamie ...Show All

• WineNCheese Matrix order of totals

  I have a matrix that shows sums by month.  The dataset returns both month and quarter.  I want to have subtotals by Quarter.  I have this working and the matrix returns columns as follows: Jan Feb March Q1 April May June Q2 ... Total What I would like to have is Jan Feb March April May ...  Q1 Q2 Q3 Q4 Total Is there anyway to have subtotals displayed at the end of the row For dynamic group ...Show All

• erikkl2000 How to add 'ALL' as report parameter in drop down with other parameters

  Hi ALL,    I would like to add 'ALL' to other report parameters.The other report parameters are counties.I would like to add 'all' so that user can select all counties from drop down. I added union select 'ALL' to sub query.  in main query    @county='all' is it right or wrong.After I did this report is running very very slow.performance problem begins. what exactly is the procedure to do. thanks r sankar Hi, ...Show All

• vbhelp SSIS login error

  i gave a non admin user access to SSIS. He is able to log in to SSIS without any problem. But when he expands the MSDB folder, he gets the following error: The SQL server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2005 Books ...Show All

• LDJ SSIS Access from SQL Server Management Studio

  I am trying to develop a package using SSIS to get rid of Informatica. But I am not able to connect to the SSIS from the SQL Server Management Studio. The error message is 'Connect to SSIS Service on machine XXXXX failed: Access denied'. I am using Windows authentication and I am in the DTSADMIN role. I have 'dbo' privileges in all the databases in the Server where the SSIS Service is running (Yes, I checked and the SSIS Service is running). ...Show All

• Cyber Wombat Help with CustomComponent in SSIS-DataFlow

  Hello Trying to figure out a clever solution for splitting multivalued columns out into n-columns. For that I've build a custom component in SSIS using ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/dtsref9/html/4dc0f631-8fd6-4007-b573-ca67f58ca068.htm as an example. I need to be able to add columns to the OutputCollection in designtime, but the designer returns an error: Error at Data Flow Task [Uppercase [5910]]: The compone ...Show All