title: How to debug stored procedures in an environment where Visual Studio user has limited rights?
body: <p>I've read the Visual Studio 2010 documentation that says that it is possible to attach a debugger and step thru a stored procedure the same way I can step thru .net or JavaScript code in Visual Studio 2010.</p>
  
  <p>However, when I try to do this, I see the error message: <code>User 'dbo' could not execute stored procedure 'master.dbo.sp_enable_sql_debug' on SQL Server XXXXXXXXXX</code>.</p>
  
  <p>I spoke with my DBA regarding this issue.  He says that there is no way of allowing debugging without making the developers admin users, which is a non-starter in the environment in which I work.</p>
  
  <p>The first work-around that comes to mind would be to install SQL Server Express on the developers' workstations, but this is also not allowed; it is absolutely verboten by the powers that be.</p>
  
  <p>I realize that this seems like an arbitrary situation, and it a way, it is.</p>
  
  <p>I would like to ask if there is some way to enable SQL debugging without making the developers admin users and without having any database server running on development workstations.</p>
  
  <p>As an aside, I am not a DBA.  My DBA says that he doesn't know much about Visual Studio, so I wouldn't be surprised if there is some obvious solution we've overlooked.  Our SQL server is MS SQL.</p>