What does kick you out mean? The application closes? It must be corrupted then.

Are you modifying user stored procedures?

http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

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