title: Is there a way to give debugging rights for a particular database in SQLServer?
body: <p>In SQLServer 2008, there are multiple databases available. I have <strong>db_owner</strong> rights for a particular xyz database, but the Sys Admin is not able to give me <strong>sysadmin</strong> rights, which are required to debug a stored procedure stored in the  database.</p>
  
  <p>Can anyone guide me regarding how to <strong>debug a stored procedure</strong> written in the xyz database?</p>