Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
t1g312
Posting Yak Master
148 Posts |
 Posted - 2004-08-04 : 02:59:51
|
| Hi all,I want to add the option of changing sql server password from my VB application. The problem is that only changing the password of sa works. How do I allow the user to access sp_password?ThanksAdi-------------------------/me sux @sql server |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-04 : 10:31:37
|
| Any sql user (not windows authentciated) can change their own password using sp_password, as long as you don't pass the third parameter @login you should be able to do it.Raymond |
 |
|
|
|
|
|
Changing Password