I have a couple of questions about this article:

1.) Are the plans cached by sp_prepexec stored in the same place as the plans cached when using Stored Procedures?

2.) Do you think that it is a bug with SQL Server that plans created using sp_prepexec are not re-used across connections?

3.) Does the "per connection" plan re-use behaviour change between versions of sql server 2000/2005/2008?

4.) If you are calling SP's from ADO.net are the plans re-used across connections in a web application?