The attributes of a large number of login accounts can be managed by defining a login profile as the default for all login accounts, a subset of login accounts, or individual login accounts.
The attributes of login profiles are associated with login accounts using the following precedence:
Attribute values from a login profile bound to the login
Attribute values from a default login profile
Values which have been specified using sp_passwordpolicy under the following circumstances:
A default login profile does not exit
A login profile has not been defined and bound to the account
The login profile is set to be ignored (the parameter with login profile ignore is specified for the command create login)
The default value for the attribute