15

What is an extended stored procedure in SQL Server?

Mehdi Charife
  • 722
  • 1
  • 7
  • 22
thevan
  • 10,052
  • 53
  • 137
  • 202

2 Answers2

20

Extended stored procedures are stored procedures that call functions from DLL files. You can read the article How to use extended stored procedures to learn more.

However, extended stored procedures are deprecated and you should avoid using them if possible. CLR Integration should be used instead.

Marek Grzenkowicz
  • 17,024
  • 9
  • 81
  • 111
  • 1
    +1 for Deprecated note and link, was asked in a skills matrix and I was like, I don't know of such things, are they new? - LOL – EaziLuizi Oct 17 '16 at 13:40
1

They reside inside the master database, you can use the command "sp_helpextendedproc", in respective database.

See below screen shot:

enter image description here

kenlukas
  • 3,616
  • 9
  • 25
  • 36
Manish Sharma
  • 11
  • 2