Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: sp_executesql

T-SQL Script to find the names of the StoredProcedure that has used dynamic SQL

This article has the script that will be useful to find the names of the  Stored procedure that has used dynamic sql within the definition of the Stored procedure . In this post , I am creating a sample database with four stored procedures to show an example on how the script works :

Published July 27, 2013
Categorized as Scripts Tagged dynamic procedure, procedure, script, sp_executesql

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.