How do I change the SA password and turn off the SQL security policy in SQL 2005?

Prev Next

How do I change the SA password and turn off the SQL security policy in SQL 2005 using OSQL?


C:\Documents and Settings\Administrator>osql -E -S.

1> ALTER LOGIN sa WITH CHECK_POLICY = OFF
2> go
1> exec sp_password NULL, 'pharos', 'sa'
2> go