April 19, 2005 at 5:28 am
I would like to be able to change the password for users accounts without knowing what their current password is. I can do this in Enterprise Manager and have looked at sp_password to be able to do it in Query Analyser - however it appears that I need to know the users password even though I am logged in as SA
April 19, 2005 at 6:03 am
No, if you are sysadmin you can do:
EXEC master.dbo.sp_password @new = 'NEWPASSWORD', @loginame = 'LOGINNAME'
The old password parameter is optional.
April 19, 2005 at 6:09 am
Agreed with Chris. You should check your permissions again.
April 19, 2005 at 6:19 am
Ahh - that's excellent!
Many thanks for your help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply