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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:05 PM
Points: 321, Visits: 571
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, August 6, 2014 3:01 PM
Points: 14, Visits: 162
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: Friday, August 29, 2014 4:29 PM
Points: 588, Visits: 900
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: Wednesday, August 27, 2014 1:05 PM
Points: 321, Visits: 571
Ok, thanks for the help.
Post #1530745
Posted Wednesday, February 5, 2014 5:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 3:01 PM
Points: 14, Visits: 162
Thanks for your help!
Post #1538430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse