Rialtus (rialtus) wrote,
Rialtus
rialtus

Unlocking a user account (MS SQL Server 2005)

ALTER LOGIN UserLogin WITH PASSWORD = 'NewPassword' UNLOCK

If you want to force a password change (and really, why shouldn't you at this point), add MUST_CHANGE at the end.
Tags: reference, sql
Subscribe
  • 1 comment
  • 1 comment

Comments for this post were locked by the author