All geek questions in one place

Where is SP_EXECUTESQL defined?

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

I know that it exists because it is used by one of my deprecated workplace code. But where is it? Where can I find it using MS SQL Server Management Studio?

+4
source share
3 answers

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

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

This is an extended stored procedure, and you cannot do anything useful with discovering it (other than managing permissions).

+11

master → → →

+2

It is present there if you run this query `sp_helptext sp_executesql you will receive (Server Internal), because" sp_helptext "are extended stored procedures, so you cannot see them. They are processed in dll, but not in TSQL. Link to this link https://technet.microsoft.com/en-us/library/ms175200%28v=sql.105%29.aspx

+2
source

Source: https://habr.com/ru/post/1627184/

More articles:


All Articles