I think priming can matter, but I'd like to think that there are many more things which would come up in a meeting that would overwhelm the primed pump.

And I'd...

Gail has the best suggestion for this. Be aware you may have locks on the tables as you move them, so pick a lot activity time.

I like Phil's suggestion and that's what I go with. It could get complicated to try and merge these rows using SSIS.

I think this might be a generic error in that having a single member as part of the group. There might be a setting that wants to have more than...

You'll have to provide more information about the table and what you are doing. What type of transfer are you doing, what is the table DDl, etc.

Also, there's no such...

I haven't tried it, but the remote install should work. Haven't seen a lot of issues reported on it, though I doubt many people do use it.

What I would recommend...

I prefer the join conditions.

update x

set date = getdate()

from inserted i

where i.PK = x.PK

Gail, not sure if this is a language thing, seeing brackets in your post...

As a technology, nothing it wrong with Access. It fits in places, but it also is deployed to many people that get themselves into trouble with databases. In many ways...

True, you have to do the backup, but you don't have to stop work while you do it and can keep the DB up.

If that doesn't matter, detach will...

Good idea, I'll add one somewhere. Despite my desire to have less forums, this makes some sense.

You'd think I'd be used to typing 2008 by now.

The core of 2008 is the same as 2005.

I'd like to think that's the minority, but who knows. When you're struggling to find a job, you can really be driven to do things. At least he's asking. Hopefully...

There's a nice dojo in Seattle I went to with Gail. Likely that will be a yearly stop at PASS. Anyone's welcome to join us.

David,

That's a good point. I think that's what I've learned to do over time just for expediancy's sake.

I'm not sure one is much faster than the other, but you need to determine why you can't get a backup. What is the error?

If you detach/attach, be sure you...