I'd follow Eric's advice. SQL Agent has some good features for scheduling, using proxy accounts, notification, etc.

You could use isql (or SQLCMD) and the Windows Scheduled (Scheduled Tasks), but it's...

Once the snapshot is used to revert the main database, the snapshot is lost.

To get back to a point in time with the main database different from when the snapshot...

I assume you have free space on the drive, correct? Also, is there free space listed in the database?

What's the error and what does the package do? Hard to say what the exact problem is.

Also, if you post int he correct forum, you'll get more responses. (moved to...

If you updated with SP2, it should have only been for one instance. Is that not the case?

You uninstalled once instance, how many do you have and are they others...

We have about 350 people in the SQLServerCentral.com linked in group and you're welcome to join.

I think showing off your profile and discussions is great for your resume if you've...

They should be.

I've rarely used the debugger, in part because it was slightly flaky in 2000. But I did find a few uses where it was helpful.

I'd disgree on your solution as...

I agree with Christian. It should be simple, but if you have issues, you don't want your current installation gone if you can avoid it.

Be sure you have good backups...

Carl is correct. You need to take a full backup immediately otherwise you are not really protecting your data.

Moved to 2000.

Also, look up cross tab reports. It seems that's what you're looking for.

Gail is correct. A database is part of the server, which is used to access it. If someone can access the server administratively, they can access the data.

If this is...

Something else to look at 🙂

I think you can write those off here in the US as well.

Thanks for the great comments and it's interesting to see how people view training. In my training business...

Probably won't make the podcast, at least as long as I'm editing. Maybe if the kids decided to "help" out, they'll slip it in.