SQL Server Performance Forum – Threads Archive
user creation which cannot be droppedI 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."
<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />
That won’t stop another sysadmin dropping the login.