I'm with Jeff. I work for Red Gate and heard great things about SQL Compare (haven't used it).

However my process is here: http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart4/526/

That's part 4, go backwards to part 1

First, did you add named pipes to the server? I'm not sure named pipes works through routers. I think it's a networking issue. You can use sp_configure or EM to...

Maybe you could explain the problem and we might have ways to help.

You can copy the database a few ways, but I'm not sure how that changes your backup process....

There is no better. It's whichever works better for you. I don't believe that maintenance plans work for differentials, so you might need to use scripting. You could use the...

You need to check the linked server credentials to see what's there. You can either have set credentials for everyone, rights for some people and not others, or pass through...

Not in QA or EM as far as I know.

Some text editors would do it. I use EditPlus and it would do it.

If certification helps you, here's an easy way to get certified. Use that SQL 2000 experience and add a line to your resume!

Is this a shared app? You can set IIS to send through a particular set of credentials (like a service account) for anonymous users. Then you can add this as...

CU6 is the latest rollup released. They have gone to the practice of releasing the KB and some affected bugs before they release the rollup. My guess is that they...

Either one can be used. They both can accomplish full and log backups, so it's a matter of preference.

What is the problem?

To upgrade replicated systems, there is an order which is listed in the upgrade documents. I believe it is distributor, then publisher, then subscribers.

http://www.baarf.com

R5 is worse for both under load.

not sure how this question go through. I don't even remember seeing it, but I must have approved it for some reason.

I'll reword and change it around. Points will be...

Go with Raid 10 or 1 for everything. Avoid R5 for performance reasons.

If you can separate out the OS from SQL data/logs, do that. If you can separate out logs...

I like Lynn's approach, but you do need some type of response to the client to let them know if the update took place. Or at least logic in the...