I recently restored a database from tape.
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has

Hi dear all,
   Anyone have news about the future of BI Accelerator in  Yukon SQL
version? What do you think about SQL BI Workbench announced by Microsoft?

I have to recover a database and redirect it to another
server with the same database name.  Every time I run the
job, I get "Unable to attach to <servername>.
A network connection to the device could not be

Hello, I'm pretty new at SQL Server, so please bear with me.
I have 4 customer tables each of which have different Primary keys (customer
numbers). Each of these tables is receiving new records daily and there may
be duplicate records contained between them.

We are looking at deploying a data warehouse solution soon that has been
being developed for a few months. The development team has been working on
developing this for the company. Soon they will be turning this over to the
DBA group to do some level of integration testing with the ...

All,
When I process a new cube, I receive this error:
Analysis Server Error: More than the maximum of 64,000
dimension member children for a single parent

Can you please share with me if you are aware of any good books on SQL
Server reporting services.
Many Thanks
Simon

HOw to set the field (Password) in sqlServer database to '*'
For example
I key in VB : 12
In SqlServer database should appear : **

Does anyone know of a tool that will allow you to submit
an MDX query string and get a result set?  Maybe there is
one that is installed with AS and I am just missing it.  
Thanks,

Looking for info on the noted error message received:
General network error. Check your network documentation.
[SQLSTATE 42000] (Error 11).  The step failed.
Basic file import INSERT job failed on data warehouse.

I run a fairly large SQL 2000 db (50GB), processing between 1MM-2MM new
event records (time series) per day....spread out evenly throughout the day.
With this application once I roll to a new month, the data from the prior
month is useless and I need to get it out of the db quickly ...

We have a large number of (Crystal) Reports ( based on Stor Proc ) running
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.

We are currently in the process of looking into setting up a Data WareHouse
in SQL2000 so that we can use Cognos to report on the data.
I am looking at what hardware to run SQL2000 on just for the DWH. On all of
our other SQL2000 servers we have a very VERY simply hardware config of ...

I have a created a ragged dimension on OLAP manage but it is not being
displayed properly in Excel. Whereever empty level is there, excel displays
same value as parent. Any idea why it is happening ?

Does anyone know of a way to tell when a particular row in
a table was last changed.  We're doing some trouble
shooting and the info would sure come in handy.
Thanks,