Can't find xp_cmdshell

I am missing xp_cmdshell from our master database, how can I restore it?  Thank you.
nkuoAsked:
Who is Participating?
 
MikeWalshConnect With a Mentor Commented:
the dll is called xplog70.dll

search your machine for that to make sure it exists and exists in your sqlserver binn directory (should be where all of hte other dlls are.. if it is in the wrong path, the below won't work and you will have to put it in the right path.. by default they all go to: C:\Program Files\Microsoft SQL Server\Mssql\Binn )


sp_addextendedproc 'xp_cmdshell', 'xplog70.dll'


A word here first.. are you sure it is missing? do you have SA level access, have you looked for it under extended stored procedures in master, or are you just receiving an error when running it?
0
 
nkuoAuthor Commented:
I looked everywhere.  It is also a webserver so it may have be disabled on purpose.  I need it back to run some export jobs.  And yes, I did connect as SA as well.  
0
 
MikeWalshCommented:
ok. then do what I suggested.

But be careful because it may have been removed for security concerns, and it does open up security problems. Sounds like you are aware of that and will take steps to rectify that..

just follow my process to add it above after verifying the .dll exist.s

If the .dll is missing, you may have to get it off of an installation cd.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
nkuoAuthor Commented:
Thank you very much.  
0
 
MikeWalshCommented:
no problem. did it work for you?
0
 
nkuoAuthor Commented:
Hi Mike, haven't tried it yet but thought about what you said, since I have to put the data in a temp table anyway, I'm going to DTS the data to another server (xp_cmdshell still there) and run the sp from there.  Thanks again for the info, you definitely get the points for sp_addextendedproc.  Thanks again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.