1) Have you installed the oracle client on the server?

2) Have you rebooted the server afterwards?

3) Can you connect to the linked server by using the Oracle Tools on the...

Can you use the sql profiler to trace your stored procedure?

If I use this:

"select max(id) from ... where max(id) < @parameter" - for the previous row &

"select min(id) from ... where min(id) > @parameter" - for the next row

I think...

In access you can relink your linked tables dynamically using VBA.

http://www.mvps.org/access/tables/tbl0012.htm

You could read in the connection setting using a startup parameter, configuration file ...)

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