Login Restriction

[Sritanu _ Ghosh]

I am working at VS2008 and SQL Server2005.I want to put login restriction that after 100 logins is done by the same user after that he will not able to log thruogh the user name. :(

[Lost User]

On the database side you can use SQL Server's logon trigger to count the user's logins. On the app side you are on your own.

[Sritanu _ Ghosh]

Thanks for your reply.Can you give the query for SQLServer2005.Pls help me.

[Lost User]

No, because there is no query. I suggested either a trigger or counting it in your app. Neither requires a query.