>Hello everybody!
>
>I am looking for some help in design automation server with SQL Server backend, using ADO object.
>
>If somebody has experience with this, please help.
>I have a common question manily for ADO.
>
>1. Is it good or bad to use ADO command object for running stored procedures?
>2. How I can run SP if command object is not recomended. It seems like I am having a problem with it.
Also see this utility from the UT Downloads:
http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,54,Forum=5,28,1196 , it will generate some of the code you need to call a SQL Server stored proc from VFP via an ADO command object.
HTH