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 individual option, enter:
sp_passwordpolicy 'clear', option
To turn off all password policy options, enter:
sp_passwordpolicy 'clear'
See the Adaptive Server Reference Manual: Procedures for the complete sp_passwordpolicy syntax.
