Friday, March 19, 2010

Script to Unlock SQL User account

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

No comments:

Post a Comment