I have many stored procedures with...
EXECUTEpermission given to role
XXXLoginis created and assigned to the role of
There is one particular stored procedure that I have issue
- When I run it, there is no problem
- When I run it as
XXXLogin, it won't return any result, not even hit the first line which is a print.
- Why is this happening ?
- How to fix it?
Thank you so much.