SQLServerCentral / SQL Server 2005 / SQL Server 2005 General Discussion / How do i Set Password Expiration days for a SQL Login / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 02:27:25 GMT20RE: How do i Set Password Expiration days for a SQL Loginhttp://www.sqlservercentral.com/Forums/Topic435492-149-1.aspxUse the LOGINPROPERTY method to find all the infos you need (http://msdn.microsoft.com/en-us/library/ms345412.aspx).Tue, 05 Oct 2010 08:32:11 GMTOliiiiRE: How do i Set Password Expiration days for a SQL Loginhttp://www.sqlservercentral.com/Forums/Topic435492-149-1.aspxHi! I just read this thread (3 years later). Does anybody know how I can get a notification that someone's password will expire in another n days? or to trigger an SP to take action n days before expiry? I'm assuming an SQL server login with Enforce Password Policy and Enforce Password Expiration. Thanks in advance ...Tue, 05 Oct 2010 08:18:04 GMTmike.stone.emailRE: How do i Set Password Expiration days for a SQL Loginhttp://www.sqlservercentral.com/Forums/Topic435492-149-1.aspxAs far as I know, if the SQL Server is on a domain, the domain's password policy is the one that's enforced. If the server's not on a domain, then the local password policy is enforced.Mon, 24 Dec 2007 01:30:36 GMTGilaMonsterRE: How do i Set Password Expiration days for a SQL Loginhttp://www.sqlservercentral.com/Forums/Topic435492-149-1.aspxHi,Thanks a lot!Sun, 23 Dec 2007 23:38:52 GMThaichellsRE: How do i Set Password Expiration days for a SQL Loginhttp://www.sqlservercentral.com/Forums/Topic435492-149-1.aspxHicheck this outhttp://www.mssqltips.com/tip.asp?tip=1088Sun, 23 Dec 2007 23:05:52 GMTChiragNSRE: How do i Set Password Expiration days for a SQL Loginhttp://www.sqlservercentral.com/Forums/Topic435492-149-1.aspxHi,Thanks for your response. How can i set the Interval for Password Expiration.Sun, 23 Dec 2007 22:40:33 GMThaichellsRE: How do i Set Password Expiration days for a SQL Loginhttp://www.sqlservercentral.com/Forums/Topic435492-149-1.aspxHiIf you are creating logins from SSMS you check the checkbox which says "Enforce password policy".If you are using a script use the CHECK_EXPIRATION option of the "Create login" statement.Fri, 21 Dec 2007 04:45:20 GMTChiragNSHow do i Set Password Expiration days for a SQL Loginhttp://www.sqlservercentral.com/Forums/Topic435492-149-1.aspxHi,I am creating a Login in code while Installation. I have a requirement now that Login should have Password expiration policy. How do i set this? Please help.ThanksChelladuraiFri, 21 Dec 2007 00:09:09 GMThaichells