New password complexity checks

You can use these options, which support password complexity checks, in a new stored procedure interface; their values are stored in the master.dbo.sysattributes table.

To turn off an option for an individual option, enter:

sp_passwordpolicy 'clear', option

To turn off password policy options for all passwords, enter:

sp_passwordpolicy 'clear'