title: Finding all Stored procedures calling a function
body: <p>How can I find out all the stored procedures that are calling a particular user defined function in SQL Server 2005.</p>
  
  <p>Or how to assign a defult value to a parameter in a user defined function so that when a stored procedure calls that function and does not pass any value to that parameter function assumes the default value.</p>
  
  <p>Regards,
  Abhishek jain</p>