Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

How to call a stored procedure in an ActiveX Script in SQL Server 2000

Hi all.

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))
AS
WAITFOR DELAY @interval
GO

Open in new window

0
printmedia
Asked:
printmedia
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Like you execute a SQL query from ActiveX Script.
0
 
printmediaAuthor Commented:
Could you give me an example?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
0
 
ZberteocCommented:
Why need a stored proc instead of directly calling the WAIFOR DELAY command?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now