HI

I m a newbee to vb.net.

I am executing stored procedure through vb.net application, it throws error permission was denied on execution of stored procedure but when i execute through query analyser it works.

even i tried using GRANT EXECUTE  ON [usp_testexcel] TO [username] but still it doesnt work.

find enclosed error

____________________________
Rishi

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.