What servicepack are your sql servers running at? SP3 or SP4?

At which keyword have you seen that implicit transaction is linked to

ANSI_NULL_DEFAULT ?

SQL options control ANSI compliance options.

ANSI_NULL_DEFAULT

Allows the user to control the database default nullability. When NULL...

Any dynamic sql breaks the ownership chain.

Perhaps you could make a view which is an union of the history tables, and have your stored procedure select on the view.

Then you...

since you expect name as output parameter

CREATE PROCEDURE STUDENT (@CARD varchar(27), @CODE int, @YEAR int, @SEMESTER char(10), @CLASS varchar(50) output, @NAME varchar(20) OUTPUT) (output was missing)

Sure semester is char(10) and...

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?