The "Analysis Services Processing Task" in DTS is the task you need. Create a package that uses this task to process your cubes.

Then schedule this to run...

You can get away with running the CREATE INDEX command(s) on the publisher and the subscriber. This might be a little quicker than dropping the article because you will...

EM honours the permissions that have been granted to a user. So if a user has select or db_datareader then that is all EM can do.

However, there will be...

version 8.0.760 is what SQL Server reports after SP3a is installed. version 8.0.194 is what you get when the CD only has been installed.

I am wondering whether you completed...

The tables sysservers has most of the info you are after and sysxlogins has the rest. Restore your old master database as something like master_old and check out the...

Personally, I would have used windows authentication and simple disabled the windows account when the consultant is not around.

If you don't have Enterprise Manager installed, you will need to install DTS. Unfortunately, I don't have the SQL installation files with me but, from memory, you can install...

The service packs are intended to update the components of each of the related products that you have installed - either on your workstation or on the server.

e.g. If you...

I am experiencing a similar problem - not sure of the full reasons but try changing the default protocol using the client network utility (e.g. to named pipes).

OPENQUERY requires that you create a linked server. You cannot specify an IP address.

If you wish to use an IP address, try something like

select * from OPENROWSET...

Launch "windows firewall" (you will find this in Control Panel.

Click on "Exceptions" and then click "Add port ..."

For name type something like "SQL Server", for port type 1433.

Click on "Change...

This is probably related to Windows Firewall. When XP SP2 is installed, the default action for most ports is to close them. This means that SQL cannot be...

Declare @StringDateVarchar (50),

@DateDatetime

Set @StringDate = '15 Jan 2005'

Select @Date = Convert(Datetime, @StringDate)

Select @StringDate, @Date

What is wrong with using a maintenance plan to do this ? It requires no code, just run the wizard and your done.

DTS does not do this automatically. You will need to write some code to handle this. If the datapump is expecting a comma separated format file, then you...