I still did'n know how to run a Store Procedure using Execute. Can some one

tell me

How can I use it?



Thanks

Luis Garcia



-----Original Message-----

From: Grooten, Paul [mailto:Paul.Grooten@m...]

Sent: Miércoles, 12 de Septiembre de 2001 12:05 a.m.

Subject: RE: Running .sql scripts from ASP



Hello Louise,



You could create a stored procedure which accepts a string as a parameter.

In this proc you would use the 'exec' statement to run the sql statement you

put in the parameter. The only thing you have to do in the calling programm

is to assemble the SQL-statement you want to run. You can put this statement

in a .asp file which you can develop remote. Please note that you loose the

execution speed when using a stored procedure with an exec statement because

it can not be analyzed during the compilation of the sp. You should also

make some precautions concerning security. Only one person should have the

exec-rights to the sp, preventing possible abuse.



Kind regards,



Paul



-----Original Message-----

From: Louise Greally [mailto:lgreally@c...]

Sent: dinsdag 11 september 2001 10:13

Subject: RE: Running .sql scripts from ASP





Thanks for the suggesstion, its a possibility alright.

The reason it cant be included as a stored procedure, is that its a type

of installation/ maintenance program to run on our clients machines to

set up our database on their SQL Server, we were hoping to create the

sql scripts our end, and simply execute them on their server to set up

their db.



Finding ways to run .sql scripts is something Im having difficulty with.