Thanks for your thoughts David.

However, my experience of Microsoft support has been very negative. I think we'll do the manual approach....

Thanks,

bb

While all the above is fair and valid, I'm sure we have all struck instance where

the dynamic optimisation done by SQL is just not appropriate.

Yes, I am saying the query...

It seems nearly every site has this problem. So does nearly every database!

The best way I have seen it solved is by double encrypting all sql-login passwords:

1) Build an application...