I have a simple cube,
dimensions are time and customers (id, name, address, contry, etc), fact are
quantity
On Y axes I have to show the customer name AND the address.

I run several DTS Packages that load databases residing on two seperate
instances of SQL Server 2000 on the same server.  For security reasons, I
need to be able to set the Databases on one instance to Read/Write access,
set the database access on the other instance to Read only, ...

I have imported some mdb tables to SQL server 2005
Problem is that in access, you could specify date/time data type and use
format to display whatever you like: date or time, or both. But now, in SQL
server, data that was formatted as time is displayed as 30/12/1899 1:03:51

I am looking into using Apex SQL Log explorer's command line interface
to implement a source system data update trigger process.  The current
triggers to indicate data updates are not very reliable (surprise :-)
I was wondering if this is feasible and if anyone has attempted this.

when I use sql server user id as the autentication for the package
connection, I receive an error "The AcquireConnection method call failed with
error code 0xC0202009" while deploying the ETL solution. But there is no
issue in deploying the packages if i change the connection to ...

We are about to create a new reporting platform for our application. We
are considering different solutions and I would like to get some advice.
All the data for the application is in a Microsoft SQL Server Database and
we would like to use Reporting Services as our reporting ...

I used Excel 2003 to show the cubes in SQL 2000 analysis services.
when I show the lowest level of the customer, then add the product dimension
and Expand to the lowest level. the responsible time is very horrible.
When I look at the CPU performance on the Server, the Server is not ...

In SQL 2000 Analysis Service, Is it possible to create a dynamic MTD, LMTD,
YTD LYTD dimension in the cubes?
As it is the most common information that the user is looking for, I would
like to build a time dimension with MTD, LMTD, YTD and LYTD for the user to

All SQL Gurus,
We are in the exercise of planning and designing a data warehouse for
our company.
But at same time we are having a debate over which database to use

From: "Denny" <denny@newsgroup.com>
Subject: Linked Server - AS400 - Missing Data
Date: Thursday, September 07, 2006 3:34 PM
I set up a linked server from SQL to an AS400 and it connects ok, but does

We are about to create a new reporting platform for our HR application. We
are considering different solutions and I would like to get some advice.
We have different kind of tables, eg. Base Tables, Transaction Tables, Setup
Tables. We need to be able to print out both traditional ...

I need your assistance with 2 questions:
1. I just got my new server and ready to setup as my warehouse (Data). It's
has 2 logical drives:
a. C: at 31GB