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
SSC-Addicted

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

Group: General Forum Members
Last Login: Monday, November 21, 2016 12:48 PM
Points: 412, Visits: 766
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: Thursday, September 22, 2016 2:51 PM
Points: 14, Visits: 247
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, December 1, 2016 12:24 PM
Points: 608, Visits: 972
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-Addicted

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

Group: General Forum Members
Last Login: Monday, November 21, 2016 12:48 PM
Points: 412, Visits: 766
Ok, thanks for the help.
Post #1530745
Posted Wednesday, February 5, 2014 5:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 22, 2016 2:51 PM
Points: 14, Visits: 247
Thanks for your help!
Post #1538430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse