Saturday, July 15, 2006

Snippet://SQL Server/Change Password

To change a password in SQL Server, use the following stored procedure

sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]