Viewing 4 posts - 1 through 4 (of 4 total)
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...
October 22, 2020 at 8:55 am
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...
May 20, 2011 at 3:30 am
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...
April 15, 2010 at 4:36 am
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...
March 17, 2010 at 11:27 pm