Re: Error in rights to run stored procedure through application
If your Stored Procedure makes any changes to data held in database tables then your User Account will also need the relevant permissions on the affected tables for SELECT, INSERT, UPDATE, and / or DELETE.
The easiest way to ensure this is to make your user a member of the fixed database roles "db_datareader" and "db_datawriter"
multi-tasking - the ability to hang more than one app. at the same time.