August 24, 2011 at 12:57 am
What report can i produce monthly or weekly to list users accessing my database.The auditing feature is not available in SQL standard.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
August 30, 2011 at 6:25 am
then you'll need to write your own code to capture that info to a table, or run a profiler writing to a table just to audit login/out.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 31, 2011 at 5:27 am
,.... if not you have to depend on a third party tool to do so.
If the data is confidential which requires such level of auditing then you have to choose a tool or use Enterprise edition for such feature.
-Satya SK Jayanty
SQL Server MVP (Follow me @sqlmaster)
Author of SQL Server 2008 R2 Administration CookBook
SQL Server Knowledge Sharing network
August 31, 2011 at 11:35 am
Thank you.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply