title: locked stored procedures in sql
body: <p>I am not too familiar with sql server 2005. </p>
  
  <p>I have a schema in sql which has stored procedures with small lock on them. As I understand they were created using C#, all these locked procedures have a source file in C# with the code of the procedures. The thing is I can't access them. I need to modify one of these procedures but it doesn't let me modify them. I have the source code (from visual studio) with these procedures but when I change something in the code, it doesn't affect the procedures in the sql. </p>
  
  <p>How can I change the path to assembly in sql server 2005?  Is there any other way I can access these stored procedures?</p>
  
  <p>Thanks in advance,</p>
  
  <p>Greg</p>