0

I have already checked the dependencies, but I couldn't find where the SP is executed from in SQL Server 2016? Is there any other way to find it?

avocadoLambda
  • 1,332
  • 7
  • 16
  • 33
CodMania
  • 27
  • 8
  • 1
    If you can't find it in the dependencies, it's not called directly by any other database object. It may be called by client code or dynamic SQL. You could try [searching all stored procedure text](https://stackoverflow.com/questions/14704105/search-text-in-stored-procedure-in-sql-server) for the sap's name – Panagiotis Kanavos Jun 18 '20 at 06:50
  • For client code though, you'd have to capture a trace using eg Extended Events to see who's calling that stored procedure – Panagiotis Kanavos Jun 18 '20 at 06:58
  • Ohh okay..Thank u so much – CodMania Jun 18 '20 at 06:58

0 Answers0