What ended up being your solution?

Andy

I think 64k is a pretty good place to start since extents are 64k.

Andy

I believe the changes are saved to SQL Server Enterprise Manager.MSC, or whatever MSC you're passing to MMC.exe. I don't see it altering the registry when I change to/from the...

I've only seen it once, had to kill the sqlmaint to get it to stop. Overall I've been very happy with the maintenance plans.

Andy

Thanks for the follow up!

Andy

You're right about the system table - will have to look more, seems like back when I used Access 97 a lot it was possible to alter it, but maybe...

You can only have one identity col. Could you just copy the ident val to the other col when it's inserted, would that help? What do you use to seed...

No problem! Visit often, good questions make for an interesting site!

Andy

Only if you use the with recompile option. Some stored procedures may end up being recompiled one or more times when executed depending on the code used. Here is...

It's possible, no reason for it not to work. Use text or image for the column type, depending on whether it really is plain text through out or not.

Andy

MSysObjects in Access2K, look in the connect column.

Andy

I think it includes the size of the pointer, or the bytes if using the text in row option.

Andy

I'd double check that you have enough disk space free for it to complete, might also want to monitor to see if it's getting blocked by another process.

Andy

You should be able to edit the Access system table that contains the connect string, why not just fix it there?

Andy

This hasn't been released yet, but discusses the situation where there are two log files and one is missing/deleted.

http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp

Andy