Without changing password: ALTER LOGIN [login] WITH CHECK POLICY = OFF; ALTER LOGIN [login] WITH CHECK POLICY = ON; GO With password change: ALTER LOGIN [login] WITH password =’*****’ UNLOCK; GO http://msdn.microsoft.com/en-us/library/ms189828.aspx
Posts Tagged ‘login’
Unlock Login in SQL 2005/2008
Posted in SQL Server, tagged login, security on 14 May 2009 | Leave a Comment »
