You can use these options, which support password complexity checks, in a stored procedure interface; their values are stored in the master.dbo.sysattributes table.
To turn off an individual option, enter:
sp_passwordpolicy 'clear', option
To turn off all password policy options, enter:
sp_passwordpolicy 'clear'
Login password complexity checks are also extended to role passwords. See “Login password policy checks to role passwords”.
See Reference Manual: Procedures for the complete sp_passwordpolicy syntax.
