sp_executesql

[nigz]

I have a problem with an sp which uses the sp_executesql statement - the app has a
vb front end when running in debug all is ok but once compiled we get a
'permission denied' message - any ideas? many thanks

Regards

Nigel

 

[skuhlman]

Check to make sure that the VB application is using the same login to the SQL database as you use when running through the debugger. If it is a different username, than the database administrator will need to give the VB username the appropriate access level to the SQL system stored procedures (Execute privilege?).

 

[nigz]

Yes that's done - we're logging on via SQL security & that user has execute permissions - select permissions are also set for the involved tables - perhaps I should mention that this project is using COM+ and it seems to be tied into that security but only where the sp uses EXEC