Is this using the query analyzer? (or ODBC, ADO, OLEDB, .NET ...)

Have you specified the output parameter there too?

*side note

Please size your variables (default = 30 characters)

(@BLOCK varchar, @ROOM varchar,...

Isn't this done using

ALTER DATABASE X

MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...).

Since the interval is specified in minutes, have you tried 6 min (smaller that our interval, so sql server has to write less transaction data at a time)

Any specific hint why the table hasn't been normalized?

The spike is likely related to when sql server is checkpointing the transactionlogs. (fixed interval)

Has the recovery interval changed from 0?

from the books online

Automatic Checkpoints

SQL Server 2000 always generates automatic checkpoints....

Sql Agent also allows jobs to be run at the start of SQL Agent.

The client tools only option is on the second screen after you pick install database server

Turned out of to be a faulty usb driver. Reinstalling the mobile disk with the windows usb driver fixed it.

What is the query plan of the query on server02?

Are both server collation compatible? (is the collation compatible option on the linked server switched on or is there a specific...

If you run the package it runs under your security account.

If it runs as a job it runs under the sql server agent account.

My first guess was that sql server...

What is the security account that SQL Agent uses? Local System Account or a domain account?

Sometimes it can happen that views are mapping the wrong fields. Especially if the basetables were changed.

Is it possible to alter the view slightly so it is refreshed?

One option is a combination of SQL Agent & a job checking the event logs + SQL mail but that would be odd to report SQL Agent errors.

Perhaps a homewritten/3th party...

All jobs are executed under the SQL Agent account. Does it has sufficient permissions?

Could you post your actual code (maybe changing some names)?

Actually, my SP just having 02 cursor

where the outer cursor will pass some

info to the inner cursor to process

and update some...