where is SP_EXECUTESQL defined?

Question

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?

Martin Smith · Accepted Answer · 2016-02-04T06:51:07.363

15

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

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

edited Feb 04 '16 at 06:51

answered Feb 03 '16 at 17:14

Martin Smith

438,706
87
741
845

score 3 · Answer 2 · answered Feb 03 '16 at 17:19

3

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

answered Feb 03 '16 at 17:19

Johnny Bones

8,786
7
52
117

score 3 · Answer 3 · answered Feb 03 '16 at 17:21

It is present there , if you execute this query `sp_helptext sp_executesql you will get (Server Internal) because "sp_helptext" is a extended stored procedures so you cannot see it. They are processed in a dll rather than TSQL.. Refer this link https://technet.microsoft.com/en-us/library/ms175200%28v=sql.105%29.aspx

where is SP_EXECUTESQL defined?

3 Answers3