will help you Do the stored procedures have any special functionality, or do they just run basic hard-coded statements like "SELECT * FROM table"? If they just run basic statements, then it's probably better to get rid of the stored procedures and use dynamic SQL. This will reduce the amount of maintenance work you have to do. The old performance concerns with dynamic SQL are no longer relevant because SQL Server's caching and compilation systems are so much better now. The security concerns are obsolete as well, because you can use parameterization in dynamic queries now.
Entity Framework executes both INSERT and UPDATE stored procedures when you do INSERT
hop of those help? Unfortunately i don't think there is a way to do it without touching permissions. The only way I know to do this is to setup a user that can only call SP's (no access to any tables). in each SP, you'll have to impersonate a user that has full access to the tables using "EXECUTE AS" (http://msdn.microsoft.com/en-us/library/ms188354.aspx) Applications then use the new user you created in step one to call SP's.
Stored procedure to dynamically create insert, update, delete stored procedures