Error: The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.
To change must_change on without oldpassword
Step1: Identify the logins that have expiration checked.
SELECT * FROM sys.sql_logins where is_policy_checked=1 or is_expiration_checked =1
Step2: Launch Local Security Policy
Start-->Run--> secpol.msc
Change the Maximum Password Age and Minimum Password Length and Password must meet complexity requirements to suit your requirement
Other SQL 2005 Views related to Logins
Database-Level Views
sys.database_permissions
sys.database_role_members
sys.database_principals
sys.master_key_passwords
Server-Level Views
sys.server_permissions
sys.sql_logins
sys.server_principals
sys.system_components_surface_area_configuration
sys.server_role_members
For more information:
http://msdn.microsoft.com/en-us/library/ms178542(v=SQL.90).aspx
