We moved from SQL Server 2000 to SQL Server 2005. The client software, which I can not change, creates a user without option
CHECK_POLICY = OFF;
After creating a user, I have to run the command
ALTER LOGIN username WITH CHECK_POLICY = OFF;
Disable the policy, as recommended, I can not.
Is it possible to disable the default
CHECK_POLICY that without her
CREATE LOGIN user created with
CHECK_POLICY = OFF?