I've done something similar to what Kenneth suggested.

Have each server monitor itself. That way if your central server is down or there's some issue, the reporting still runs.

I used to...

Set min and max to the same value.

If you really need Enterprise on XP, use a VM. The software is free and you can set up a VM with W2K3 and SS2K5 Enterprise.

Otherwise use Developer edition of...

Be sure that your IP and servername match. I've seen servers that were DHCP for some reason and switched addresses.

It's possible that the alter added extents and the size hasn't been properly adjusted. You might try updating the usage with DBCC

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...