SQL : Unlock Account
Use the following SQL to unlock an account in SQL 2005/2008, simply change the account name in square brackets:
ALTER LOGIN [sa] WITH CHECK_POLICY = OFF;
ALTER LOGIN [sa] WITH CHECK_POLICY = ON;
Categories
SQL : Unlock Account
Use the following SQL to unlock an account in SQL 2005/2008, simply change the account name in square brackets:
ALTER LOGIN [sa] WITH CHECK_POLICY = OFF;
ALTER LOGIN [sa] WITH CHECK_POLICY = ON;