• jeetsingh.cs (12/13/2012)


    See you can also try to give access permission on master and grant on sp_executesql..

    That is not likely to help. All server logins automatically get a database user created for them in master and all users in master have execute permissions on sp_executesql. The issue is likely not the lack of permissions to execute sp_executesql itself, it's likely the lack of permissions of the user in the user-database that is executing the user-proc that calls sp_executesql to access the resources used by the dynamic sql submitted to sp_executesql.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato