DBCC rule... thank Ian and Paul too

😎

Ok. Ok. I know I don't want to modify system procs. We don't need to get into the details and reasons why.

Stupid question is when you right click...

Yes, you shouldn't mod sys procs... but remember "insane reason" to do so.

So, with SQL 2008, is it still possible and if so, how one be able to do so?...

Interesting topic!

So lets rephrase this question or maybe extend it a little.

You have encryption which allows you fully 'protect' your sensitive data stored inside your fine sql server database. ...

How many databases? How many sql servers?

I have about 100 db servers. Most of them are dedicated as one db server per application. Just a nature of...

So just out of curiosity... how many database server do you support and how many databases?

cheers

~Leon

How many database servers do you support? How many DBAs your company has?

I am not particularly a jack of all trades but do different things and do both production and...

Remote into another sql box with SSMS and verify that you can see the network servers from another machine.

If you can... that means you machine is 'blocking' something.

my...

use the trial version... 😉

http://www.quest.com/landing/?ID=168

Should or should not... that is not a question for others to answer.

The real question is do you need the SPs now or they are no longer needed... if so...

In my previous place.

RedGate SQL Compare and Data Compare top of the list.

Currently Toad for SQL and Oracle. Sucks for both... so I am getting myself SQL...

I've used SQL Compare starting with ver 5 for some time. It is a great tool for small to medium size databases. For large database you just have...

Good info... thanks all. I am planning SP3 install on 64-bit sql 2005 cluster and hopefully I wouldn't have much to talk about :o) other than all went well.

thanks...

And both of your servers have a different collation?

Yes, you can do it... attach/deattach db 8 and 9. I even tried db 7.0. Took sql copy. Copy db copy to sql 2005 box and created...