Login Frequency for a Login on a database

• mpalaparthi

  Say Hey Kid

  Points: 688

  More actions

  July 15, 2013 at 11:06 am

  #275994

  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

  Regards

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 15, 2013 at 11:35 am

  #1632602

  There is a method. Read this to learn how to use.

  http://msdn.microsoft.com/en-us/library/ms175850(v=sql.100).aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]