Change Password using Stored Procedure
I want to Change passsword of logged in user using stored Procedure .
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Dhruvi kukadiyaPosted Dec 29, 2014, 4:34 AM
Manish Kumar ChoudharyPosted Dec 29, 2014, 3:42 AM
The following example shows how to use ALTER LOGIN to change the password for the login Victoria from manishold to manishnew. This is the preferred method. User Victoria can execute this command without additional permissions. Other users require ALTER ANY LOGIN permission:
ALTER LOGIN Victoria WITH
PASSWORD = ' manishnew'
OLD_PASSWORD = ' manishold;
GO