Answer Questions

• stir Installing SQL Errors - Anyone please read my log file

  Microsoft SQL Server 2005 Setup beginning at Sat Jan 14 20:31:52 2006 Process ID      : 896 c:\ef878dcc6c3c3c0766424d939e4b7c78\setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/0/14 20:31:51 Complete: LoadResourcesAction at: 2006/0/14 20:31:51, returned true Running: ParseBootstrapOptionsAction at: 2006/0/14 20:31:51 Loaded DLL:c:\ef878dcc6c3c3c0766424d939e4b7c78\xmlrw.dll Version:2.0.3604.0 Comple ...Show All

• StormDev How to set default date

  Hi Guys, I have a time standard dimension used as a filter to my report. How can I set the parameter to get the current month and year to be used by the time standard filter.   Select the report, and go to Report->Parameters, select the parameter, in the default values sectoin, set the value there. You can use function too, like get current date, use =Today, and DatePart() to get year, month, ...Show All

• Emil Prager How to skip snapshot in Transaction Replication (from SQL Server 2005 to 2000)

  We have two SQL Server 2005 production DB at remote sites. Due to network bandwidth issue, we need to replicate these DBs (publishers and distributers) to central corporate SQL 2000 DB (subscriber for backup and possible reporting (and in rare case as a failover server). We would start out with backup from SQL 2000 db restored on remote SQL 2005 DBs. When we have DB issue on remote 2005 DB, we want to restore it from central corp. 2000 DB bac ...Show All

• mortalfunk Writing a Query

  Hello I'm new on sql server and I wonder if there's an specific order for writing a query's clauses (joins, and other conditions in where clause or even the order of the tables in the from clause), I mean, I have a query that takes 1 minute executing, but if I execute the same query after moving the tables in the from clause (changing the order) It takes 5 seconds, could you please tell me Why and what's the best order from writing a query ...Show All

• Pierre Charbel Advice on a database Replication

  Hi, I.m trying to find the best practice for my solution. This is the situation. My application has two databases and 2 client interface. One with a windows forms having a database (sql server 2000) running in an office (on a static IP but on a slow connection). the second one is an web application running on the net with an online database. Both these databases have to have same information. Users can add records to both databases ...Show All

• Bradrover Standard deviation calculation

  Hi. I am trying to create a calculated member that calculates the standard deviation of all child members of a displayed member in a hierarchy. To visualize it I will use an example from AdventureWorks: If I put Internet Sales Amount in the data area and the Product Catogories hierarchy in the Row Fields area, I get a list with Internet Sales Amount for each level in the Product Categories . I want to create a calculated member that shows ...Show All

• talbers SSIS Doubts

  I am having this question in my mind from when I started using SSIS.. In a package I have an OleDB source and a flat file destination. and I hook up the source to destination in SSIS and run the package.. it works .. fine.. but internally what is done does SSIS performs BCP out Whoops. I misread the original question. Thanks for picking this up Simon!! -Jamie Going from OleDb to flat file it ju ...Show All

• david cantrill Access web application is slow, should I upgrade to SQL server?

  Hi, first time poster/newbie here. I've got a football (soccer for the yanks!) predictions league website that is driven by and Access database. It basically calculates points scored for a user getting certain predictions correct. This is the URL: http://www.pool-predictions.co.uk/home/index.asp There are two sections of the site however that have almost ground to halt now that more users have registered throught the season. The p ...Show All

• sivakami Printing images problems - Transparency, Colour Palettes and Stetching

  We have been using RS 2000 with no service packs but knew that the direct printing option seemed a little tricky, so did not use it. We have now upgraded to RS 2000 SP2 to use the direct printing and have hit a number of issues. PNG Images using true colour no longer seem to export properly to PDF and come out more like a hologram on a credit card (interlacing). This is easiliy fixed by downgrading the palette to 256 colours. It has ...Show All

• Alan Lodge Where are my migrated packages?

  I have successfully migrated 50+ packages from 2000 to 2005. Where are they ! ! I looked through Management Studio and through Visual Studio ("SQL Server Business Intelligence Development Studio") and cannot find them. Note: When I open Visual Studio the splash screen confirms that Integration Services is installed.   Thanks   Ok. Yes, by starting the Migration Wizard from Management Studio, you c ...Show All

• eugene7_11 Help getting mirroring working

  Hello guys and gals, I've having some trouble getting DB mirroring set up in Sql Server 2005. Perhaps someone can help, as I've read everything I can find on the web and Google groups about this but still can't solve it. Here are the steps I have taken: 1. Installed a fresh Windows 2003 on box A (the primary) and a fresh Windows XP on box B (the mirror). 2. Run Windows update on both. 3. Installed Sql Server Enterprise on box A and box B, ...Show All

• Flores How to get a reference to output buffers in a ProcessInput()

  I'm attempting to build data-flow transform component and at the moment something just isn't clicking. Hopefully one day I'll look back and laugh at myself for asking this. I am building a synchronous component with 2 outputs. I know from reading BOL that I can get a reference to the output buffers in the PrimeOutput method but I don't think (I may be wrong) that PrimeOutput is the place to do this for synchronous components. I need to get ...Show All

• Rieekan SCD (Slowly Changing Dim) DTS vs SSIS Best Practice

  Hi there,   Is the best practice of managing change with Type II SCD used in DTS still valid on SSIS, or should we use the SCD transformer provided out of the box   Thanks. -w My answer to that would be "No". If you can achieve what you want without resorting to script then do it. And regardless of what I said above, if the SCD task does what you want (with a bit of modification)  ...Show All

• Rob1 Function with CASE Statements

  Hi, Uses: SQL Server 2000 + Winxp PRO; I Created a Function as below: <CODE> CREATE FUNCTION [GetDestinationOperator] (@Dest VARCHAR(24)) RETURNS VARCHAR(15) AS BEGIN DECLARE @Op VARCHAR(15) SET @Dest = RTRIM(@Dest) CASE LEN(@Dest) WHEN 13 THEN SET @Op = 'IDD' WHEN 10 THEN CASE SUBSTRING (@Dest , 1 , 3 ) WHEN '071' THEN SET @Op = 'MOBITEL' WHEN '072' THEN SET @Op = 'CELTEL' WHEN '077' THEN SET @Op = 'DIALOG' ...Show All

• Ikram Shaikh Displaying a List Horizontally

  Hi All, I'm new to reporting services and I need some help.  I've created a list which contains a photo and user name.  Currently, it displays all the information I want however, the list expands down the page in one column.  I would like it to expand across the page horizontally (4 columns) and then skip down to the next line.  Can someone tell me  how to do this using report designer    Thank you ...Show All