How do we Unlock Particular User in Sql Server

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

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

Bookmark It

< Previous : What is the purpose of DATENAME fucntion?

Next > : How to rename a database in SQLserver?

More Interview Questions by Nishithraj

Latest Interview Questions