Stored Procedures

[degthat]

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.

[Corey]

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.aspx?scid=KB;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 (http://www.indigorose.com)

[Brett]

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.

[degthat]

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.

[Corey]

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 (http://www.indigorose.com)