How to set CHECK_POLICY OFF in the sql script
You have to do

Alter login login_name with CHECK_POLICY = { ON | OFF }
Alter login login_name with  CHECK_EXPIRATION = { ON | OFF }


Refer: http://technet.microsoft.com/en-us/library/ms189828.aspx