0 - 2 of 2 tags for database access log

Hi All, would like to find the best practice to automate aborting all inactive sessions after certain amount of time (from SqlAssistant, client sessions). Am planning to for at stored procs and scheduler to perform the abort task on regular basis. Thanks.

Hi All,

Is there a way to track users who access a particular database in the data warehouse? Would this be done thru the DBQL? Are there any "standard" sql reports that exist for this kind of reporting? This is needed for security reporting requirments.

Thanks!

Paul