We have created a user who does not have the admin rights. How do we debug a stored procedure by logging in as the user mentioned above. If we give the admin rights to the user, then we are able to debug the procedure. But, I would like to know how to debug the SP with out having the admin rights. The user has the following rights. CONNECT and BINDADD.