John Mitchell-245523 (12/1/2011)

---

The only way I know for existing logins is to execute the ALTER LOGIN statements one by one. You can generate them very easily something like this (pseudo code because I haven't checked the syntax):

SELECT 'ALTER LOGIN ' + name + ' SET CHECK_EXPIRATION ON'

FROM master.sys.server_principals

WHERE IsNTLogin = 0

John