| Author |
 Topic  |
|
|
imransi17
Starting Member
11 Posts |
 Posted - 05/16/2013 : 12:12:06
|
Hello,
I am trying to execute a stored proc like this
Declare @cmd varchar(1000)
Declare @Path1 varchar (1000)
Declare @user_id varchar (50)
Declare @password varchar (50)
set @cmd = 'exec' + ' ' + stored_proc_name' + ', ' + @user_id +', ' + @password + ', ' + @Path1
exec master..xp_cmdshell @cmd
ERROR I am getting = 'exec' is not recognized as an internal or external command,
Please help !!!
Thanks, |
|
|
djj55
Posting Yak Master
USA
236 Posts |
Posted - 05/16/2013 : 12:15:19
|
1) do you really need xp_cmdshell?
2) have you tried execute sp_executesql @cmd? (without 'exec' at the begining)
djj |
 |
|
|
Bustaz Kool
Flowing Fount of Yak Knowledge
USA
1496 Posts |
Posted - 05/16/2013 : 12:18:52
|
"exec" is a SQL statement. xp_cmdshell lets you execute things at the OS level. The OS doesn't know what "exec" means. What are you trying to actually accomplish?
=================================================
I am not one of those who in expressing opinions confine themselves to facts. (Mark Twain) |
|
|
|
imransi17
Starting Member
11 Posts |
Posted - 05/16/2013 : 15:21:09
|
djj55, i didn't needed xp_cmdshell. you are right. it worked as
exec stored_proc_name @DB_Name, @user_id, @password, @Path1
Thank you :)
Brustaz Kool: Thank you soo much. you are right. I shouldn't be using xp_cmdshell in this format.
Thanks :)
|
|
|
| |
Topic |
|
execute a stored proc within a string through xp_c
