I'm Admin on a server here at work and I'm trying to build a database which I can publish on an intranet website. My problem is, when I try to publish my table, I get an error 'Error 2812: Could not find stored procedure 'xp_cmdshell'.
I didn't create the table under the 'master', but I do have access to it. I don't see 'xp_cmdshell' under the extended stored procedures area. I executed the DOS command: exec sp_addextendedproc 'xp_cmdshell', 'xplog70.dll'....and a window popped up asking me what application that I wanted to open this file with. The file is 'exec.vbs'. So, I open up this file in VB
and attempt to run the vbs file and get a compilation error: 'Expected:= on 'VerifyHostIsCscript()'.
I just want xp_cmdshell back on this server! How do I get it done?