Announcement

Collapse
No announcement yet.

Stored Procedures

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stored Procedures

    Does any one know of a way to run a stored procedure using Autoplay ? I have a developer who wants me to create a CD to automatically run a stored procedure on a Microsoft SQL database before copying new asp files to a web site.

  • #2
    Re: Stored Procedures

    Well it's easy enough to call a web script, i.e. an ASP page from AutoPlay and the following link explains how to call a stored procedure via ASP:

    http://support.microsoft.com/default...;en-us;q164485

    So it's definitely do-able, but there might be an even easier way which one of the Microsoft gurus around here might be able to shine some light on, not sure...

    Corey Milner
    Creative Director, Indigo Rose Software

    Comment


    • #3
      Re: Stored Procedures

      You could also write a DLL or EXE that does the work through ADO (write it in VB or VC++) and then call it from your AutoPlay application.

      Comment


      • #4
        Re: Stored Procedures

        What if I have script they want to run like you would you in query analyzer, is there away to run that.

        By the way thanks for all the info so far.

        Comment


        • #5
          Re: Stored Procedures

          Again, via ASP I see no reason why not. If you can do it with ASP then you can do it with AutoPlay... ADO I know nothing about but it sounds like it might also do that...

          Corey Milner
          Creative Director, Indigo Rose Software

          Comment

          Working...
          X