user creation which cannot be dropped | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

user creation which cannot be dropped

I want to add a super user like ‘sa’ which cannot be dropped.I am wondering how can I do so.
This I need for administrative purpose
Make him the only owner of an object that only he can drop. Not very elegant, but it should do the trick. — "Recommended By Dr. Audioscrobbler."
http://www.last.fm/user/chopeen/

<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />
That won’t stop another sysadmin dropping the login.
]]>