To lock an account
1> sp_locklogin gaurav,"lock"
2> go

To Unlock an account

1> sp_locklogin gaurav,"unlock"
2> go

To get list of locked accounts
sp_locklogin