they want to pass data between several distinct dbs on diff server groups.  
I'm way new to sql server and not sure it can be done.  Help!  I use
enterprise mngr to do bkups and such, but that's the extent of it.

all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
working excelp OLAP services, i even restarted the server. In service manager
it shows 'Starting' on status bar.  when i try to connect server through MSA
it gives me error 'cannot open connection to ...

  I'm trying to connect with Analysis Service's Database and create, see,
drop cubes with ASP.NET (programming in VB.NET). What I need to do this?
(I'm beginner with Analysis Server, but already I knew SQL Server).
Thanks.

I'm trying to decifer the data in the table that stores the data in the
binary format. All numbers are placed in varbinary fields. All I know is the
MS SQL 2000 database useing collation SQL_Latin1_General_CP1_CI_AS
(default).

SQL Express is limited to 1 CPU.  What are the ramifications to installing it
on a system with multiple CPU’s?  Will it simply bind to one of the CPU's?
Thanks for your help!

   I'm a newbie to Datawarehousing and using of the concepts of Dimensional
modeling. I read about Kimball's methodology too.
 I started using Analysis Services, which is really great. I created tables
with the primary index values.

I have a requirement for an automated process to streamline warehouse backups
(some tables only) to only 4 weeks of data for each table archived. I have a
system whereby I apply a suffix to ensure unique table names.
We have alot of old data that builds up quickly. In the near ...

First of all my apologies for this very basic question but I can n't find a
definite answers to this question.
I'm new to data warehousing and have started reading "The Data Warehouse
Lifecycle Toolkit" by Kimbal (and others). From it I understood that the

Fast food chain store (Think the likes of Burger King or McDonald's). Items
are sold separately or combined. Need to know, for each item sold, what are
the ratios that any other items are sold in the same order.
For example, one day during 5-6PM, 200 Cokes were sold in 160 ...

I have never done it before.
By the term incremental, I mean that I have a fact table and each day I want
to add records to it that do not already exist in the table. I do not want to
truncate and do a full load each day. There are millions of rows. I am

In our company, we have DB2 (currently moving from Informix) on Unix and SQL
Server on Windows are the two primary database engines.
Now, when top management decided to select a server for upcoming data
warehouse project, they selected DB2 because of more stability and again an

I have a DTS procedure that runs 4 times a day.  It has worked well until
now.  It is reading infromation from a text file. Today the text file was
empty and DTS failed giving me this error; "The volume for a file has been
externally altered so that the opened file is no longer ...

We are currently populating our WH/DM using only tools availale in SQL2K
(i.e no Syncsort etc). Some of our modules (controlled via DTS) take,
understandably, a fair amount of time to processand I was ondering if there
was a trick  was missing to speed things up. Example: -

I have a star schema where the fact table is about 1.2M rows, and about 40
measures wide (a lot, I know). I've been tuning and studying Showplan and
have performance almost where I need it. But I'm encountering something I
don't understand. When I run this query:

I am in the process of drawing up the spec for our data warehouse server. The
setup that I am having to cater for is a server that will hold:
1) a replicated copy of the tables that are going to be used to extract that
data from as we have 22 offices this will be 22 databases. ...