To add to what others have said, even though you set the permission to lock pages, that doesn't automatically lock the memory pages for you. You still have to...

I'm not necessarily boycotting SQL2008, but we have no plans to upgrade from SQL2005. I've yet to see any features worth an upgrade of my entire platform (60+ installations)....

We run SQLSafe in our environment which has multiple untrusted domains.  The official word I got from Idera is that no, they don't support SQLSafe agents communicating across domains but it's...