Search This Blog

Monday, 21 February 2011

Reset MS SQL password

hi,
To reset the password in ms sql, you please enter into the ms sql as windows authentication and move to the particular database and open sql editor and run the blow query.
SP_PASSWORD @NEW = 'New password', @loginame = 'sa'

After running the query just exist the ms sql and open and login the ms sql with new password

No comments:

Post a Comment