How do we Unlock Particular User in Sql Server

 Posted by Nishithraj on 1/5/2010 | Category: Sql Server Interview questions | Views: 2483
Answer:

First Login with Window Authentication then take Master Database
Afterwards, execute the below query

alter login databaseusername01 with password='password' unlock


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response