Script to Unlock SQL User account
Posted by Jugal Shah on March 19, 2010
Easy way without passing Password to unlock SQL user account is just check/unchecked Password policy check box.
USE [master]
GO
ALTER LOGIN [Jugal] WITH CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [Jugal] WITH CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
