Viewing 15 posts - 29,176 through 29,190 (of 39,771 total)
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
March 22, 2008 at 8:38 pm
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...
March 22, 2008 at 8:36 pm
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....
March 22, 2008 at 8:33 pm
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...
March 22, 2008 at 8:32 pm
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...
March 22, 2008 at 10:58 am
Not in QA or EM as far as I know.
Some text editors would do it. I use EditPlus and it would do it.
March 22, 2008 at 10:51 am
If certification helps you, here's an easy way to get certified. Use that SQL 2000 experience and add a line to your resume!
March 22, 2008 at 10:50 am
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...
March 22, 2008 at 9:05 am
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...
March 21, 2008 at 4:50 pm
Either one can be used. They both can accomplish full and log backups, so it's a matter of preference.
March 21, 2008 at 4:49 pm
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.
March 21, 2008 at 4:48 pm
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...
March 21, 2008 at 10:52 am
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...
March 21, 2008 at 10:20 am
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...
March 21, 2008 at 9:32 am
Viewing 15 posts - 29,176 through 29,190 (of 39,771 total)