I think the plan is to just use Rowversion.

create table Table (

ID int identity primary key,

Rowversion,

OtherColumns...)

An SQL log parser will at least tell you what transactions, if any, were the last ones run. If that will help, RedGate's log parser for SQL 2000 is...

Change them from left...

I just created a job in my ProofOfConcept database.

First step, run a T-SQL command to insert a start time into a table.

Second step, run a .BAT file that takes about...

I'm guessing, without the rest of the proc, but I bet there's a line in there that assigns a value to the parameter and uses either a malformed explicit conversion,...

With regard to this, "SQL Server caches temporary objects so that dropping and recreating them in code is very fast."

I just ran these three tests:

set nocount on

declare @Tests int, @Start...

Yes, there are plenty of places where the batch percent is just dead wrong. I'm more thinking in terms of simple select/update/delete commands, where you have multiple of those...

create table Test (

ID int identity primary key,

Timestamp, -- Like...

This appears to be a duplicate posting of one in the Adminstering forum. Replies have been posted there.

Is it running on a different server than the one it was created on?

Is it running the job under a proxy account?

Does the account SSRS is running under have the...

Instead of copying the proc into the command window, just put the name of the proc there. Usually, with "dbo." in front of the name. Try that.

Instead of a standard derived table, you might want to look into using a CTE (Common Table Expression). They have some advantages in terms of readability, etc.

As far as...

Another question is: Have you tried that installation disk on another machine? Possibly a flaw in the install disk would do something like that.

I'm making a somewhat educated guess based on index behavior.

There is a possibility that updating the clustered index affects the indexes used for the foreign keys, which might cascade to...

If you're talking about SSIS (sounds like it), you can set a watch on the variable in the dev studio.