I stumbled across some behavior in SQL2005 that I consider odd and
surprising, and I'm looking for help understanding more about it.
According to BOL, when you run "CREATE USER user_name LOGIN
login_name", the login_name must be a valid login in the server. I