See MS Knowledge base article 280730:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;280730

I opted for the 'add timestamp column to table' fix. No more WRITE conflict errors after that.

Good Luck!

bb

Problem solved....

Found out via BOL that 7.0 enterprise can only be upgraded to 2K enterprise.

Version and Edition Upgrades

Each of the editions of Microsoft® SQL Server™ 2000 (SQL Server 2000...

We're using legit MS purchased CDs.

We're going from SQL 7.0 Enterprise to SQL 2000 Standard.

Here's the first part of the log:

06:52:11 Begin Setup

06:52:11 8.00.194

06:52:11 Mode = Normal

06:52:11 ModeType =...

MSDB database sysjobhistory table

Not sure how many days the history files are logged by default. My guess would be no default.

Maybe someone else knows....

Will this work for you?

New Alert.

Type: SQL Server Performance Condition Alert

Counter: Data File(s) Size(KB)

Instance: Database Name to monitor

Set your counter rules.

Here is the reg key...

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion]

"checksum"=hex:37,36,32,32,63,31,35,38,61,65,37,64,34,63,64,37,35,30,64,61,30, 33,34,62,37,64,63,33,37,66,33,34,33,30,35,63,38,66,66,32,34,31,39,36,34,64, 34,64,37,35,33,31,63,37,31,33,34,65,65,63,37,34,32,30,34,37,39,30,33,31,66, 31,38,36,35,65,61,63,38,63,62,38,62,61,30,39,64,31,62,33,30,37,37,37,37,62, 64,66,33,66,64,33,39,66,30,38,66,33,31,34,63,62,37,65,37,38,35,33,63,66,64, 63,31,64,61,32,62,31,31,31,30,31,30,38,64,37,37,61,36,62,34,38,36,64,63,66, 62,38,32,62,34,62,35,64,00

"RegisteredOwner"="------"

"SerialNumber"=dword:88420040

"CurrentVersion"="7.00.623"

"CSDVersion"="7.00.1063"

"CSDVersionNumber"=dword:00000400

"Language"=dword:00000409

I had a similar Access2K/SQL2K problem. I resolved it by adding a column of datatype timestamp to the tables. Even though my app doesn't use it, it stopped the write...

I figured it out.

I created a stored procedure out of the script and have DTS executing the SP. Also I stopped concatenating the results together and it works brilliantly....

In my production script (which is considerably longer) I do HAVE to build a temp table to get the result set it need.

I don't think I did a good job on the post.

Here's another way to tell me what I want to know.

Take the above script and export the results to a...

Thanks for the reply.

The script that I have written requires creating temp table to be able to get the final rowset...so I can't use a view (to my knowledge).

Here...