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'
See the Reference Manual: Procedures for the complete sp_passwordpolicy syntax.
