Can you provide the error? Also, can you try to break up the steps you are taking in your process? You've run together a number of steps into one sentence...

I like Sergiy's copy/drop/rename solution if it works. sometimes it's much quicker to work with inserts than deletes.

If that last suggestion works, it would be amazing to me. It shouldn't matter, other than forcing a new execution plan. But if the optimum plan is chosen, then it...

Which 3rd party utility do you have? Some take the place of the native backup, Some don't.

The native backup utility works great and is nearly flawless. Some of the third...

Do you mean that you changed the Windows account in AD and the SQL account did not change?

The SQL accounts are linked by SID, but the name is also stored....

This (http://support.microsoft.com/kb/281574) seems to imply that it should be the retail version if you upgraded.

I would at the very least set an alert for the day before expiration and be...

Do you mean 3 errors in one batch or transaction? I believe only the last one will be returned with the alert. Not sure of a way to get around...

IF it's a number, you might need to CAST it as a character string as well before combining it with a plus (+) and the zeros.

Are you saying that you are moving files as in data files to new filegroups? Or are you talking about data?

It's not clear exactly what your package is supposed to...

Each client has multiple transactions, I'm assuming, so that's why you get more values.

You could select the types, but use the MAX( date), group by the owner_id, and that should...

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