Post reply

User Access to sql server

  • April 30, 2007 at 1:24 pm

    #153558

    Is there a way to identify users within SQL Server that have not accessed a database within 30 days?

     

    Samuel

  • May 1, 2007 at 8:51 am

    #703552

    Easily.... No. 

    You can enable the "Audit-Level" server property to record logins in the SQL Server log and Windows Application Event Log.  Then you would have to parse and analyze these logs to get what you're after.

    You could also use the SQL Profiler in a similar fashion.

    The C2 level auditing available in SQL Server is probably way overkill for you.

    Then there are some third party tools available from companies like Idera.

    Here is a link with some further discussion:

    http://sqljunkies.com/Forums/ShowPost.aspx?PostID=11184#11189

     

  • May 7, 2007 at 2:49 pm

    #704774

    Thanks you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply