Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to check if xp_cmdshell is running or not?

Author  Topic 

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2008-05-02 : 13:48:31
If possible, in both platforms, 2000 and 2005.


---
http://www.ssisdude.blogspot.com/

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-05-02 : 14:03:55
for either sql server version:

sp_who2 should show the xp_cmdshell command and status

examining the OS processes on the sql server box should show whatever process was launched via xp_cmdshell (assuming it is still active)

Be One with the Optimizer
TG
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-03 : 20:31:45
Check if it's enabled with sp_configure.
Go to Top of Page
   

- Advertisement -