If it's on all databases, you can use the undocumented stored procedure: sp_msforeachdb

http://www.mssqlcity.com/FAQ/Devel/sp_msforeachdb.htm

Duplicate... see your other post.

That's a limitation of AS, you can redesign the dimension by making groups of data.

Also, you can set the GROUPING setting of each level to Automatic, this will cause...

We have some 'changing' dimensions here, the only issue is that every time you process the dimension, AS has to recalculate the aggregations of each cube containing the dimension, depending on how...

We have Samba installed on our Unix-boxes and put our files on shared folders that can be accesed directly from windows.

I've done this with calculated members using FORMAT_STRING, like this:

WITH MEMBER Measures.Profit AS'(Measures.[Sales] - Measures.[Cost])', FORMAT_STRING = '#,0.00'

I think this can also be used in the cell properties section to...

The sintax of the MDX is like this:

SELECT {[Dimension]} ON PAGES,
{[Dimension]} ON COLUMNS,
{[Dimension]} ON ROWS 
FROM [Cube]

Also, I think you can use the pivottable object to desing the report.

We have an HP Proliant DL560 G1 / 4CPU and 8.5GB RAM, with W2003 Enterprise and SQL2000 Enterprise with SP3.

The system has enabled /3gb and /PAE switches in BOOT.INI.

When...

Try to go to the directory where the files of the database are stored, then delete the files with the same name of the dimension. Start the server again. After...

BOL = Books OnLine ..... The help for SQL and AS.

I've just answered the question, but it appeared like the email (Enterprise Edition) and I answered 8GB because I assumed that you were talking about Advanced Server, but got it wrong!

What is...

You can backup to network from EM, when you create the device or set the destination for the backup enter the UNC path, don't try to browse it since EM will...

To update the sysservers table you have to run:

sp_dropserver old_name

GO

sp_addserver new_name, local

GO

This immediately changes the value in the sysservers table.

For the variable @@SERVERNAME to reflect the change, you have to...

Look at this:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133

In windows2003, you can run only SQL Server 2000 with SP3.

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp