Hi!

>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.


Take a look to following article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp

>I have a common question manily for ADO.
>
>1. Is it good or bad to use ADO command object for running stored procedures?

It is good, as far as I know.

>2. How I can run SP if command object is not recomended. It seems like I am having a problem with it.

Run it as SQL command text, for example, put instead of SELECT statement following string:
EXEC MyStoredProc {parameters}

You can run SP that way even using recordset object, if SP returns recordset.

HTH.