InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 19:36:48 GMT20http://www.sqlservercentral.com/Forums/Topic967196-146-1.aspxHi,You guys are really helpful. I really appreciate your reply on this, it save me a lot of time. Thanks. :-DWed, 11 Aug 2010 21:17:10 GMTJimmy.Liewhttp://www.sqlservercentral.com/Forums/Topic967196-146-1.aspxAll the pieces from above, all put together.[code="sql"]SELECT 'ALTER LOGIN ' + QuoteName(name) + ' WITH CHECK_POLICY = ON;' FROM sys.server_principals WHERE [type] = 'S' -- SQL Server Logins only AND principal_id > 1 -- not sa - omit this line if you want to include it[/code]Wed, 11 Aug 2010 09:24:55 GMTWayneShttp://www.sqlservercentral.com/Forums/Topic967196-146-1.aspxUse [b][url=http://msdn.microsoft.com/en-us/library/ms189828.aspx]ALTER LOGIN[/url][/b] in conjunction with the above query to turn on CHECK POLICYWed, 11 Aug 2010 08:49:11 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic967196-146-1.aspxThis hould give you all SQL accounts (so no domain or built-in accounts)And then you will have to write a script to wrap around each account and turn policy either on or off.[quote]SELECT name, loginname FROM syslogins WHERE name NOT LIKE '%\%' AND name NOT LIKE '#%'[/quote]Wed, 11 Aug 2010 03:12:29 GMTSchadenfreude-Meihttp://www.sqlservercentral.com/Forums/Topic967196-146-1.aspxHi all,Can anyone like to share how to list all the logins from syslogins system table, later change all the "CHECK_POLICY=ON" if it is "OFF".Kindly advice. Thanks.Wed, 11 Aug 2010 01:43:39 GMTJimmy.Liew