Cute

Please post your findings - I am sure all would appreciate it !

I do not know about SQL 2008 or SQL 2008 R2.

(maybe in another month I will though)

This seems to shoot down 2 of my 3 mantras:

Design for performance,

Code with clarity,

Implement with precision !

I need to ask few questions - possibly searching for the answers the root cause(s) of the problem may become more apparent. Well here goes my starting list:

- How...

Quite simply you need to learn 'his language'. This implies using 'business' terms instead of 'technical' terms - you'll need to 'dumb it down' - just how far is a...

It is a good thing to initially log and notify on this type of message. However there may be underlying storage subsystem issues that need to be tackled immediately. These...

The groups do not need to be touched for things to function correctly.

If those local groups need to be renamed due to auditing requirements your only choice in an un-install/re-install...

Steve, the difference between 'practicality' and 'purist' seems like an insurmountable chasm.

However, until we reach a shift in the ways we think about 'bugs' as I had mentioned earlier, this...

Triage and prioritization seem the most logical however there will always be disagreement as to what is the correct mix and/or outcome or the process.

I maintain the 'purist' point of...

If you like ....

what you do ...

who you work for ...

and

who you work with ...

compensation more than just your pay is just a plain bonus !

(although it is nice)

Dependent on your DR scenario no scripting may be required.

Usually in a DR situation you will be loading/recovering user databases.

Why not just precede this with a recovery of the master...

There is a command line parameter to add or you can perform a registry hack to achieve the same result.

However you may encounter issues if you attempt to start/execute processes...

when using AD groups in this situation you'll need to check with your Windows Admins to make sure that 'Kerberos Delegation' is turned on otherwise you will end up in...

Here are a two suggestions:

Why use individual users, how about using Active Directory groups ?

(This may take a bit of analysis and lunch for the AD/Windows admin)

Now the low-tech, but...