title: How to I step through a .NET assembly stored in SQL Server (CLR)?
body: <p>I need to step through and debug an assembly uploaded to SQL Server.</p>
  
  <p>The developer who created this project was kind enough to make the comments in the script:</p>
  
  <pre><code>-- Use the following line of code to create the assembly from a file when making frequent changes to the assembly during debugging.
  CREATE ASSEMBLY asm_MY_NAME FROM 'C:\myDir\myDLL.dll'
  
  -- Use the following line of code in order to debug CLR methods in this assembly.
  ALTER ASSEMBLY asm_MY_NAME
  ADD FILE FROM 'C:\myDir\myDLL.pdb'
  </code></pre>
  
  <p>I successfully run the following two statements on a freshly compiled DLL, but I have yet to figure out how to step through the code.</p>
  
  <p><a href="http://blogs.msdn.com/b/sqlclr/archive/2006/06/29/651644.aspx" rel="nofollow">This article</a> indicates all I have to do is attach</p>
  
  <blockquote>
    <p>to any client application that opens a database connection to SQL
    Server</p>
  </blockquote>
  
  <p>My project is a Web Applicaton.  I've tried attaching through chrome.exe to see if the debugger catches my breakpoint.</p>
  
  <p>I also tried attaching to sqlservr.exe and that did not work either.</p>
  
  <p>What could I be missing to be able to step through code?</p>
  
  <p><strong>EDIT:</strong>  Also tried aspnet_state.exe; no luck.</p>