I have a stored procedure that accepts a parameter for the length of time to delay and I want to use it in an ActiveX Script that is in a DTS.
How can I call this stored procedure from within an ActiveX Script?
Thank you in advance.
CREATE PROCEDURE spDelay (@interval CHAR(9))
WAITFOR DELAY @interval