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

My guess is that you need to drop the endpoint and recreate it.

Users are not schemas. Do you mean you need to know which object is owned by a user?

If this is the user schema, then you could easily see from object...

How is the linked server configured? Are logins mapped? It is possible that there is a misconfiguration here.

Do you mean Integration Services packages? Maintenance Plan packages??

These are stored in msdb in various tables. You could give SELECT access to these tables to the developer.

This problem usually occurs when you are trying to get data into a space into which it will not fit. I'd actually recommend exporting this data (and decrypting), then bringing...

Are you using a passphrase or encryption by password?

The database master key should exist with the database. If anything, when you restored, you'd need this to continue to the restore.

The...

I don't think that there is anyway to slip data into the stream that would be susceptible to SQL Injection. I suppose it's theoretically possible to slip into the replication...

You do not drop the key or you will not be able to decrypt values. You assign users the ability to use the key. Typically you wouldn't encrypt with an...