InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 16:07:12 GMT20http://www.sqlservercentral.com/Forums/Topic362096-119-1.aspx<P>Thanks you<img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'></P>Mon, 07 May 2007 14:49:00 GMTPrem-321257http://www.sqlservercentral.com/Forums/Topic362096-119-1.aspx<P>Easily.... No. </P><P>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.</P><P>You could also use the SQL Profiler in a similar fashion.</P><P>The C2 level auditing available in SQL Server is probably way overkill for you.</P><P>Then there are some third party tools available from companies like Idera.</P><P>Here is a link with some further discussion:</P><P><A href="http://sqljunkies.com/Forums/ShowPost.aspx?PostID=11184#11189">http://sqljunkies.com/Forums/ShowPost.aspx?PostID=11184#11189</A></P><P> </P>Tue, 01 May 2007 08:51:00 GMTEd Zannhttp://www.sqlservercentral.com/Forums/Topic362096-119-1.aspx<FONT size=2><P>Is there a way to identify users within SQL Server that have not accessed a database within 30 days?</P><P> </P><P>Samuel</P></FONT>Mon, 30 Apr 2007 13:24:00 GMTPrem-321257