1. I don’t know if you can do this. I would go about this using .net code inside an Orchestration to call your Stored Procedure. The adapter is really intended to bring data into BizTalk and send data to SQL.
2. As far as I know, you need the ide to run the wizard. It creates the asp.net projects for you and set them up in iis. You might want to look at this: http://www.masteringbiztalk.com/blogs/jon/PermaLink,guid,3998ad88-372b-4daa-8544-c32cda32c922.aspx
Hope this helps.