Check the times on the servers and please let us know if you determine the cause.

In SQL 7, I believe the only way to do this is with an uninstall, reinstall of the server.

Seems like Dundas is the primary one I see out there.

You contacted their support?

Also, moving this to the reporting services area.

DO NOT USE REPair_allow_data_loss.

You can try to repair the table but moving the data out and reading around the structures, but it might not work. This is really worth the...

There aren't daily ones.

what are you trying to do? What is IMP?

Or what have you been asked to do? If you're new to being a DBA, there are quite a...

Is this DTS? Please post in the DTS area (I'll move).

One thing you can do is save this as a "VB" file. It's an option if you do SAVE As....

Do you really need SP4?

I doubt you'll get support on this. Any reason why the base OS can't be changed?

It's indicated in the registry keys, but it doesn't affect operation.

Sounds like a bug.

Is this the first time the job was run? Have you checked the raw data in the msdb tables?

I don't and I'd ask that this be turned off for now.

Call MS while you still have time before support ends next spring.

Also, I think the server must run under a domain account.

I'm not sure if your script has a problem. I think you need this to be two separate batches, so a GO might be needed between these commands.

However, there's no...

I'm not really a collation expert, but since 2000 (and in 2005), databases can have separate collations, so there isn't an impact with the server collation.

If you are moving data...

Does this occur regularly?

Not sure if you can do some sort of exclusive lock in Access.

You could export to a new file, then drop the old, rename the new.

Not sure you would want this, though it's possible that you have different developers that have rights to create objects in the schema. In that case, the object owner and...