title: sp_prepare and sp_execute
body: <p>I've been consulting google for some time now, but it hasn't been able to give me a satisfactory answer...</p>
  
  <p>In a SQL Server 2005 trace, I've got lots of "exec sp_execute" statements. I know they are connected to a corresponding "exec sp_prepare" statement which specifies the actual SQL.</p>
  
  <p>But...</p>
  
  <p><strong>One:</strong> Is it possible to find out the SQL behind the sp_execute without finding the sp_prepare?</p>
  
  <p><strong>Two:</strong> What type of construct would typically hide behind the sp_execute? That is, is it a stored procedure? Is it just a string in code? Or what?</p>
  
  <p><strong>Three:</strong> Should I fear bad performance seeing these in the trace?</p>
  
  <p>Any input is appreciated</p>