sanjay s sarsambi (5/2/2016)
Steve,The script is really helpful.It runs perfect on SQL 2012, when I run it on SQL SERVER 2008 getting the below error. Can you help here, please.Msg 207, Level 16, State 1, Line 64
Invalid column name 'authentication_type'.
Check the update at http://www.sqlservercentral.com/scripts/login/138379/. That should work on 2008 as well without error.