Change SQL Server user login account password script:
Sometimes you need to change the password for a particular user in that case following script will help you to change the password.
in following Example :
Login account user name is : dbdevwebuser
Current password is : MyCurrentPwd
New password is : MyNewCurrentPwd
We can use following script to change the users login password.
Sometimes you need to change the password for a particular user in that case following script will help you to change the password.
in following Example :
Login account user name is : dbdevwebuser
Current password is : MyCurrentPwd
New password is : MyNewCurrentPwd
We can use following script to change the users login password.
ALTER LOGIN dbdevwebuser WITH PASSWORD = N'MyNewCurrentPwd' OLD_PASSWORD = 'MyCurrentPwd'Happy Coding !!
No comments:
Post a Comment