Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trace Script for XP_CMDSHELL Expand / Collapse
Author
Message
Posted Tuesday, September 17, 2013 11:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 397, Visits: 730
Is there a way to use a trace and capture only when XP_CMDSHELL is used, and what used it?

Post #1495608
Posted Monday, January 13, 2014 12:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:56 AM
Points: 14, Visits: 224
Bump
Post #1530411
Posted Monday, January 13, 2014 12:33 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, May 19, 2016 9:55 AM
Points: 604, Visits: 961
You could run a profiler trace (server side trace) to capture Text Data that contains %xp_cmdshell% and then add the columns you want to see i.e. Host Name, Login, etc.



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1530415
Posted Tuesday, January 14, 2014 9:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 397, Visits: 730
Ok, thanks for the help.
Post #1530745
Posted Wednesday, February 5, 2014 5:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:56 AM
Points: 14, Visits: 224
Thanks for your help!
Post #1538430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse