Use sp_addlogin to set the password expiration interval for a new login.
This example creates the new login joe with the password “Djdiek3”, and sets the password expiration interval for joe to 2 days:
sp_addlogin joe, "Djdiek3", null, null, null, 2
For details on the syntax and rules for using the new parameter, see sp_addlogin.
