call a stored porcedure

Last Post 08 Sep 2004 04:02 AM by fedem73. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
fedem73
New Member
New Member

--
08 Sep 2004 04:02 AM
i'm tryng to execute this comamnd in a store procedure,

declare @CMD VARCHAR(150)
set @cmd = 'rwrun60 c:\pr.rdf userid=sys/manager@magia destype=file desformat=pdf desname="c:\produz.pdf" batch=yes'
exec master..xp_cmdshell @cmd

if i create a new stored procedured named testand in i run it in sql (exec dbo.test), the command work, but if i try to inserto the command exec dbo.test in onother stored procedure the comamnd don t work.

someone could help me
thanks a lot
You are not authorized to post a reply.

Acceptable Use Policy