>How do I create a stored procedure in SQL from within Vb.Net?

You can drag a SQLDataAdapter from the Toolbox onto a form. This will start a very flexible wizard that will help you create a set of stored procs (and optionally copy them to SQL Server). If you don't want the adapter on the form after you're done, just remove it. I can't imagine it would delete the sp's you created with the wizard. You can do this even if you only have Pro (that's all I have).

In addition, I have heard good things about CodeSmith also, but I'm still in the experimental stage with it.