EXECUTING XP_CMDSHELL IN MS SQL/ATTACHING MDF

From: Rene Relucio


	Quezon City Philippines
	Rene Relucio

Subject:	Executing xp_cmdshell in MS SQL/Attaching MDF
Thread ID:	101949	Message ID:	101949	# Views:	2	# Ratings:	0
Version:	Visual FoxPro 8		Category:	Databases, Tables and SQL Server
Date:	Thursday, July 20, 2006 9:07:44 AM

Hi Experts!

I am trying to use xp_cmdshell, an extended stored procedure in MS SQL 2000.

In the update trigger, I EXECUTE a stored procedure. In this stored procedure is the statement:

EXEC xp_cmdshell 'copy c:\sqldumps\pubs.dmp \\server2\backups\sqldumps',
NO_OUTPUT

However, I get a message:
Could not find stored procedure 'xp_cmdshell'.

The User account initiating the update trigger has a system administrator role.

HYCH

Regards,

Rene-PCSO

ENTIRE THREAD

Executing xp_cmdshell in MS SQL/Attaching MDF Posted by Rene Relucio @ 7/20/2006 9:07:44 AM

RE: Executing xp_cmdshell in MS SQL Posted by Borislav Borissov @ 7/20/2006 9:22:50 AM

RE: Executing xp_cmdshell in MS SQL Posted by Rene Relucio @ 7/20/2006 2:04:47 PM

RE: Executing xp_cmdshell in MS SQL Posted by Borislav Borissov @ 7/20/2006 2:38:10 PM

RE: Executing xp_cmdshell in MS SQL Posted by Rene Relucio @ 7/21/2006 4:08:16 PM