Friday, March 23, 2012

Reset password

How does one use SMO to reset a login password?

Thanks..

Server s = new Server(".");

Login l = s.Logins["Jens"];

l.ChangePassword("OldPassword", "NewPassword");

//Or the short one

new Server(".").Logins["Jens"].ChangePassword("OldPassword", "NewPassword");

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment