October 18, 2007 at 6:39 am
I can find no way to change a user account password with Studio Express. How can this be done?
October 19, 2007 at 8:12 am
Use T-SQL, from BOL:
ALTER LOGIN login_name
{
| WITH [ ,... ]
}
::=
ENABLE | DISABLE
::=
PASSWORD = 'password' [HASHED]
[
OLD_PASSWORD = 'oldpassword'
| ]
]
| DEFAULT_DATABASE = database
| DEFAULT_LANGUAGE = language
| NAME = login_name
| CHECK_POLICY = { ON | OFF }
| CHECK_EXPIRATION = { ON | OFF }
| CREDENTIAL = credential_name
| NO CREDENTIAL
::=
MUST_CHANGE | UNLOCK
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 19, 2007 at 8:58 am
from the UI side, right-click on the user, and go into properties.
If you don't have access to the PW, then it's a windows user. Change those from the OS.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply