Hello,

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?

Thanks beforehand.

What are you attempting to do? Which table are you referring to?

I created a new Database with one table (just to test table)...and I wanted to see this via a webpage. The structure of where I created it within the SQL Server Enterprise Manager -> Console Root\Microsoft SQL Servers is:

Microsoft SQL Servers -> This computers name...(which is the server)
-> Databases -> My New Database Name.

And under that, I created a Table. I just want to see this database/table test so that I have a general feel for what it looks like, how to begin implementation of the full scale database that I'm interested in creating for online publishing.

Thanks!