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

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

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:21 AM
Points: 293, Visits: 499
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: Wednesday, March 12, 2014 4:57 PM
Points: 14, Visits: 160
Bump
Post #1530411
Posted Monday, January 13, 2014 12:33 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 17, 2014 10:48 AM
Points: 534, Visits: 790
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:21 AM
Points: 293, Visits: 499
Ok, thanks for the help.
Post #1530745
Posted Wednesday, February 05, 2014 5:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 4:57 PM
Points: 14, Visits: 160
Thanks for your help!
Post #1538430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse