Thanks for the note!

I agree with Phillip and if you call MS, they'll almost certainly require SP2.

Is this an SP1 box or has this happened on SP2?

I think it would be interesting, especially pointing out the issues with delete_file.

If you're game, I'd like to publish. If not, I can find someone else to do it.

If you have land, you don't have to go deep. You can go horizontal and get the 500ft in a loop that's 15 ft down. The catch is you need...

You probably need to write a SELECT query and qualify it with a WHERE clause.

However as a student, you need to research this stuff and show some effort towards solving...

Most things should function the same. You might need to rebuild indexes/update statistics, but you can set the upgraded db to SQL 2000 mode (8.0 compatability) and things should work.

If...

If you run a select instead of a delete on the rows and compare the two values (2k and 2k5), is the data the same?

I'd be suspicious of something changing...

Can you provide more information about what you were doing that caused this error? Is this in working with SQLAgent?

If there's a size issue, I'd think it would be with Exchange. Can you send the file from your account with no issues? Can you log into the server with...

This help?

create table MyParent

( myid int identity(1,1)

, myval char(1)

)

go

create table MyChild

( mychildid int identity(1,1)

, myid int

, mynewval char(1)

)

go

insert myparent select 'A'

insert myparent select 'B'

insert...

Have you checked sysjobschedules to be sure the old job still isn't in there?

Also, moved to the SS2K forums. Please watch the titles when you're posting.

Sure, I'll edit it down to the cursing, the missed logs, and a few huffing/puffing shots 😛

My guess is that because there are two errors returned, you only get the last one. I don't see a good way to do this by digging through documentation.

It's possible...

Is this a SSIS add-in? Your programmer (or you) interested in writing and article and sharing?

The forum code probably doesn't account for the differences in the US. The server is on US time (MDT currently), so it will switch this weekend.