Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Audit listing of Select Statements Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2008 10:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 5, 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
Posted Wednesday, January 30, 2008 9:08 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 10:17 AM
Points: 14, Visits: 213
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
Posted Wednesday, January 30, 2008 9:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 11, 2014 1:41 PM
Points: 2,278, Visits: 3,058
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
Posted Thursday, January 31, 2008 1:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 6:03 AM
Points: 312, Visits: 1,127
Take care - C2 Auditing seemed to cause my server to crash.

Disabled it and no crashes since (6 months).
Post #449835
Posted Thursday, January 31, 2008 3:58 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:00 PM
Points: 421, Visits: 364
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 »

Add to briefcase

Permissions Expand / Collapse