I really very thankful to all members of SSC. Well I have come across a situation... I want to track all the INVALID LOGINS into SQL Server Database. If someone is attempting to login to SQL Server with incorrect Login Details then a TRIGGER should be fired to INSERT that details into one Database Table.
Please help me to resolve this out.