Post reply

Initiate a program

  • August 24, 2003 at 4:00 pm

    #59430

    I currently have a situation where a table is constantly monitored for new rows(query every 30 seconds) by a vb program (running on another box). Obviously this creates lots of activity. I would like to set up a trigger instead, but I don't have any idea what would be the best strategy in starting the program. Any suggestions appreciated.

    Thx! John

  • August 24, 2003 at 4:30 pm

    #471127

    Start an application from a trigger normally will rise an eyebrow or two.

    How about another table in which your trigger can add a record/flag to indicate there is data to be processed to a scheduled job which will then execute the VB app.

  • August 25, 2003 at 12:34 am

    #471150

    Hi John,

    what is this VB programm supossed to do?

    I think you should go for 5409045121009 (who is he? ) suggestion.

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 25, 2003 at 12:56 am

    #471153

    John,

    Do you need to go according to your Tech. Specs?! or are you designing tech specs.?

    If you are in the begining stage, I think better choice would be teh way siggested by 5409045121009.

    .

  • August 25, 2003 at 5:08 am

    #471201

    Thanks for all the input. I don't think I expressed my problem very well. Perhaps I should have asked... 'What is the best way to initiate a VB program on another computer'.

    Thanks again!

  • August 25, 2003 at 5:17 am

    #471202

    quote:

    Thanks for all the input. I don't think I expressed my problem very well. Perhaps I should have asked... 'What is the best way to initiate a VB program on another computer'.

    in this case I think xp_cmdshell would be first choice.

    Maybe use COM via sp_OA*?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply