Hi,
How can i get the login attempt in sql server.
OR
I am working in Naviosion 2009r2 (my new company have Navision ,actuality I am a C#.Net developer ) and it is using Sql Server as database.Maximum number of users allowed in Navision is 54 (Actually Navision is using sql users for login), so when 55th user trying to login ,it blocks the new user with a message . So i need to write a trigger ,which executes when the user try to log in ,and in the trigger if some user idle time is grater than a specific time (say 1 hour ) then the idle user need to disconnect , so new user is allowed to login .
Thanks&Regards,
Aadyakumar.D.V