I'm all for the stored procedures method. Since they are precompiled they run faster than sending SQL statements over the wire. They also make security easier to implement because you only need to grant execute rights on the procedure and not to individual tables. They can also prevent disasters because you can't execute delete statements directly on a table.

On the client side, input parameters can easily be created on the fly. I have a method in my base cursor class that does this.

Another thing I like is the seperation of code between client and server. Having all your action queries reisiding on the server makes the project easier to manage.

Charlie