Very Computer

I am in the middle of constructing a "data cleaner" for a
client and they have asked for the ability to dynamicly
create their own stored proc's.

Any help would be greatly appreciated.

Thanks,

Don

Yes, you can do that. What you need to do is to prepare your SP text as a
string in Vb and execute prepared string using Execute method of ADO
connection or Command object

Dim lcSQL as string
Dim loConnection as ADODB.Connection
......
lcSQL="CREATE PROCEDURE ....."
loConnection.Execute lcSQL

Now you will have SP, stored in database and you could execute it
--
Val Mazur
Microsoft MVP

Quote:> I have a question regarding stored procs.  Is it possible
> to programmaticly build a stored proc (from VB6), save it
> to the server and run it at a later date?

> I am in the middle of constructing a "data cleaner" for a
> client and they have asked for the ability to dynamicly
> create their own stored proc's.

> Any help would be greatly appreciated.

> Thanks,

> Don