This should be very simple, but I haven't found the solution yet. I'm writing a Q&D application to setup log shipping for a large number of databases. I need to execute several stored procedures (e.g. sp_add_log_shipping_primary_database)
which will return a value plue two output parameters that I need. I've taken the code generated by SQL Server and executed it in a SMSS query window. I've tried configuring an ADODB command with EXEC
sp_name parm1, parm2, ..., parm 12 OUTPUT and setup parameters on the command without success (The connection cannot be used to perform this operation.). I tried stringing all of the statements needed together in one line separated by semi-colons
(executed without error but didn't return any values).
I'm using VB2010 and SQL Server 2008. Any suggestions would be appreciated.
View Complete Post