sp_helpextendedproc (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_helpextendedproc(nvarchar @funcname)

MetaData:

 create procedure sys.sp_helpextendedproc -- - 1996/08/14 15:53  
@funcname sysname = NULL  
as  
  
set nocount on  
  
if @funcname is not null  
begin  
    --   
    --   Make sure the function name exists  
     --   
    if not exists (select * from master.sys.all_extended_procedures  
            where name = @funcname)  
    begin  
        raiserror(15019,-1,-1,@funcname)  
        return (1)  
    end  
    -- print out select function name info --   
    select distinct name, dll = substring(dll_name,1,255)  
    from master.sys.all_extended_procedures  
    where name = @funcname  
    order by name  
end  
else  
--   
--   or print out all function name info  
 --   
select distinct name, dll = substring(dll_name,1,255)  
    from master.sys.all_extended_procedures  
    order by name  
  
return (0) --  sp_helpextendedproc