>Will remote server (exe) execute a stored procedure? If it will then should I just say DO sp_name ?
>Thanks Mark
well, you have to create a connection or use a connection that you have stored in the database...
nConnection = sqlconnection('MyConnection')
Then, use SPT to run the SP
***********
Um.. of course, if you are talking agout a local SP... then...
set database to mydata
do sp
Will work great.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only