Interesting you've never used it. I use this as a first glance when I get a complaint about a new server. It's a thumb-sketch to see if this is grossly...

Moved to SQL 2000 forum.

what is the issue you are having or are you just looking for information?

XP supports encryption, but it's a CPU cycle issue from what I've read. I haven't tried one, but perhaps enough complaining will get my boss to buy one 🙂 for...

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