Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing User/Login Password
Message
From
10/06/2003 19:13:37
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00798679
Message ID:
00798685
Views:
21
This message has been marked as the solution to the initial question of the thread.
You need to use the store proc sp_password. It's documented in BOL.

>I know have my application users logging into SQL Using the SQL Users/Logins. How do I change the password on a sql user from within code? My users have to change passwords every x days, during the login process, I determine if the x days is reached and if so, prompt them for a new password. But now that I'm using the SQL users/logins I don't know how to do that.
>
>I'm assuming I'll be able to do something like this?
>
>
>update sysusers set password=?lcNewPassword where username=user_name()
>
>
>Thanks
>Kirk
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform