Database Reference
In-Depth Information
select * from sys.sql_logins
Figure 1-13.
Viewing a SQL login from the master database
If you attempt to create the login account in a user database, you receive the error shown in Figure
1-14. The login must be created in the master database.
Figure 1-14.
Error when creating a login in a user database
If your password isn't complex enough, you receive an error message similar to the one shown in
Figure 1-15. Password complexity can't be turned off.
Figure 1-15.
Error when your password isn't complex enough
