Login Frequency for a Login on a database RRS feed

  • Question

  • Hello SQL Experts,

    I have a SQL Server 2008 Standared Edison server and I have 3 database with both SQL Logins and windows logins.

    Is there any way to find out, how frequently a login (could be windows or SQL logins) is accessing the database per week.

    (For ex: lets say there is a  database name "sql2k8" and there is a sql login "login_sql" and a windows login "login_windows" that are part of that DB (sql2k8). I would like to find out how many times the logins "login_sql" and "login_windows" are accessing the database per week

    Hope I'm clear in explining.

    Thanks for all your help

    Monday, July 15, 2013 5:28 PM


All replies