I know in sybase if you login with SSO role and use sp_password procedure
and supply sso password, It will change the users password.

sp_password @caller_password, @new_password, @login_name


Hope it helps.
-----Original Message-----
From: Shawn Smith [mailto:[Email Address Removed] Tuesday, June 11, 2002 3:38 PM
To: '[Email Address Removed] Changing all of the users passwords at once


Does anyone know if there is a way to use a cursor to loop through and
change everyone's password back to password even when I do not know there
current one....maybe using the sp_password procedure?

Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page