Search code examples
sql-servert-sqlsp-executesql

where is SP_EXECUTESQL defined?


The 'SP_' prefix by convention suggests a system stored procedure. But nowhere in my SQL Server instance could I find the sp_executesql stored procedure.

I know it is there because it is used by one of my workplace's legacy code. But where is it? Where can I find it using MS SQL Server Management Studio?


Solution

  • Where can I find it using MS SQL Server Management Studio?

    master --> Programmability --> Extended Stored Procedures --> System Extended Stored Procedures

    It is an extended stored procedure and you can't do anything useful with it having found it though (apart from managing permissions).