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 [url]http://www.sqlservercentral.com/columnists/orcsweb/changingsqlserverpasswords.asp[/url]
[i]By: OrcsWeb Team ([url]http://www.sqlservercentral.com/columnists/orcsweb[/url])[/i]