title: Find a stored procedure name with its content in SQL Server 2000
body: <p>For a stored procedure, I have its full source code. But the <strong>name</strong> of that stored procedure has been lost. In this database, there are hundreds of stored procedures.</p>
  
  <p>So is there a way by which I can find out the <strong>name</strong> of the stored procedure by using its contents or by using any of the variables in the contents?</p>
  
  <p>This is puzzling me a lot. A help would be sincerley appreciated.</p>