You can use this utility to transfer the packages:

DTSBackup 2000

http://www.sqldts.com/default.aspx?242

If you are using xp_cmdshell check the permissions for the proxy account.

Does it display any error?

If you are looking for tables you have to add xtype to the previous query:

select * from sysobjects where name = 'yourTable' and xtype = 'U'

Also, you can query the...

At least, it will occupy the space already used of the DB. You can see this on Enterprise Manager or sp_spaceused.

Yes them can be processed, since private dimensions exists only within the cube.

You can try the JDBC Driver.

http://www.microsoft.com/downloads/details.aspx?FamilyID=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

Yes you can, if you process each cube without processing related dimensions. Before to process the cubes, process the shared dimensions.

Have you seen MDX Sample Application that comes with AS? You can run MDX Queries from it, it's similar to QA.

It depends on how many rows you insert/delete and the reovery model of the database. If the recovery model is FULL it will log every insert/delete you issue.

There is a registry key to restrict the version of the client. This was instroduced on SP3.

The key is: ConnectPre80SP3Clients

Check this:

http://support.microsoft.com/?kbid=905615

After this, you have to assure...

Try to create a log and see which row is failing, it seems that there is one row that has missing or extra columns.

To configure a log file, right-click on the...

Revoke just delete any explicit permission you gave to a user. If you wat the user not to access de table you have to use DENY.

If you just added the user...

Also, this free utility show the ports:

http://www.sysinternals.com/Utilities/TcpView.html

You can see it in Server Network Utility, select TCP/IP protocol and click Properties. Also, you can find it in the SQL Error Log, look for a line that starts...

You have to run DBCC TRACEON in order to the other connections see the new trace flag.

From BOL:

DBCC TRACEON

"...New connections into the server do not see any trace flags until...