Complete a Server Assessment – Failed Logins

Below you will find the code for the Index Fragmentation for an object.  Simply select the text and copy to the Clipboard.

EXEC sp_readerrorlog 0, 1, ‘Login failed’

This code was written using the Microsoft SQL Server documentation.  If you find that this code was copied from else where, please let me know so I can give proper credit.