SQL Server 2000 does not have the best or most secure password mechanism. In fact it does a pretty poor job of managing passwords and forcing changes. From the very knowledgable web team over at Orcsweb, a short article on how you change passwords in code.
Author: Phillip Carter
Created on: Friday, 18 February 2005
Full article available at http://www.sqlservercentral.com/columnists/orcsweb/changingsqlserverpasswords.asp
By: OrcsWeb Team (http://www.sqlservercentral.com/columnists/orcsweb)