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