Jeffrey William.

hi, usually the CPU core and RAM for each SQL instance should be half than before as we have to take care the failover of BOTH instance TOGETHER to...

How about the option 'provstr' when adding linkedserver? it seems it is only work for mirror session, right? can it solve our problem ?

Once the @provstr string specified, should @catalog...

from SQL 2005, I found that the most safe method is to create one more account with sysadmin righ t and then deny the access of builtin\Administrator account to SQL...

How can I do the same thing for all user database without running this script for all database one by one ?

I am looking for a way to do it...