well said, Major. It's the "what" it says that causes so much debate.

apparently it's a hot button issue, however since this thread is one of the most posted to in...

Feel free to pass it along. I know there are lots of virtualization questions out there.

You can right click the SQL Agent and script out a bunch of this stuff as well. Packages you have to move manually.

I have seen issues installing SP3 from some people, but I haven't seen anyone report issues with the server.

no, these are specific to each instance.

Are the server and client on different SP levels.

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