The options that support password complexity checks are discussed in this section. You can use these options in a new stored procedure interface; their values are stored in the master.dbo.sysattributes table.
To turn these password options off, use sp_passwordpolicy. 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'
