Is this possible ? Preferably to put it into a dts package after processing
cubes...in SQL Server 2000
performance tuning it is recommended to do this but if it's a manual
procedure it's not so good.

--Michael V.

You can use Net Stop ... Net Start cmmand prompt commands and put them into
Windows scheduler.
But: I don't recall seeing such an advice, and I don't agree with it. Can
you give use URL where you read this?

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

Thanks Dejan

Not an URL - a book....

SQL Server 2000 Performance Tuning, ISBN 0-7356-1270-6

Page 246...."In a MOLAP solution, however, it's completely acceptable to use
a local SQL Server database as a temporary data store for the star schema.
If you do use SQL Server as a temporary storage mecahnism, you might want to
shut down the SQL Server Service after the build process is complete,
freeing valuable system resources."

By temporary I interpret it as my subject area...?

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka (AT) avtenta (DOT) si> skrev i en
meddelelse news:ODpnms1rEHA.3848 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

OK, this makes sense. If you have SQL Server on the same box, and your users
browse OLAP cubes only, then it makes sense to shut down SQL Server after
the cubes are processes.
Temporary storage - I would expect the author means Data Staging Area, i.e.
tables an procedures for data cleansing.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com