Audit listing of Select Statements

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Audit listing of Select Statements

Audit listing of Select Statements

Rate Topic

Display Mode

Topic Options

Author

Message

jbechard

Posted Tuesday, January 29, 2008 10:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2008 8:31 AM
Points: 1, Visits: 7

I'm looking for a method for monitoring/auditing browsing.

I'm aware of Lumigent, but after reviewing the hooks that it needs into the database/network I'd like to find a simpler alternative.

Is there a 'simple' way to output a listing of Select statements in SQL Server -- not the results returned - just the Select statement?

James

Post #448993

Eric Desch

Posted Wednesday, January 30, 2008 9:08 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 18, 2013 2:19 PM
Points: 14, Visits: 211

I don't know if you will consider this "easy" but SQL Server Profiler should do the trick. Look for the event class 'TSQL'

EKD

Post #449482

Adam Haines

Posted Wednesday, January 30, 2008 9:46 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:29 PM
Points: 2,278, Visits: 3,011

You could enable C2 auditing. C2 auditing can be detrimental to performance and is not always 100% accurate, but it provides a very robust method for tracking access to SMOs. The output file can be launched via profiler and is quite legible.

more info:
http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/
http://msdn2.microsoft.com/en-us/library/ms187634.aspx

My blog: http://jahaines.blogspot.com

Post #449515

ianT

Posted Thursday, January 31, 2008 1:16 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 310, Visits: 1,003

Take care - C2 Auditing seemed to cause my server to crash.

Disabled it and no crashes since (6 months).

Post #449835

G.R.Prithiviraj Kulasingham

Posted Thursday, January 31, 2008 3:58 AM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, October 21, 2012 8:59 PM
Points: 421, Visits: 362

Take care - C2 Auditing seemed to cause my server to crash.

C2 Auditing is handled through trace events. I prefer to use customized trace (store them to a file.)
You can automate it.

Profiler has UI, trace doesn't have one, other than that fucntionality wise you will capture the sme information.

Cheers,
Prithiviraj Kulasingham

http://preethiviraj.blogspot.com/

Post #449857

« Prev Topic | Next Topic »

Permissions