Problem executing stored_proc 
Author Message
 Problem executing stored_proc

I am trying to execute the xp_cmdshell, does it not allow variables? I
printed the variable to be executed at the end and it is perfect. Any
ideas for a workaround?
The code is below for my proc.  Thanks in advance.

snyper.




















Sun, 11 Aug 2002 03:00:00 GMT
 Problem executing stored_proc

Gary - you don't need the quotes.  The below worked for me

















 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (412 entries) see

http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk



Sun, 11 Aug 2002 03:00:00 GMT
 Problem executing stored_proc
Thanks!!
Quote:

> Gary - you don't need the quotes.  The below worked for me

















>  Neil Pike MVP/MCSE.  Protech Computing Ltd
>  (Please reply only to newsgroups)
>  SQL FAQ (412 entries) see

> http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
>  or www.ntfaq.com/sql.html (+ ntfaq download)
>  or http://www.sql-server.co.uk



Tue, 13 Aug 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. CALL stored_proc from CLI problem...

2. cann't run stored_proc on a transfered DB

3. Problems executing executing store procedure on different environments

4. Execute DTS from asp.Net failure because that package contain execute SQL task

5. _ conn.execute or cmd.execute?

6. Calling/Executing Execute SQL Task from DDQ

7. command.execute vs. connection.execute

8. Execute a child package using Execute Package and ActiveX Script tasks

9. ADO: cmd.Execute vs cn.Execute

10. Execute statement executes twice?

11. command.execute didn't get executed sometimes

12. Executing DTS from T-SQL builiding, executing and destroying JOBs


 
Powered by phpBB® Forum Software