Difference between Stored Procedure and extended Stored Procedure

Question

What is the difference between  Stored Procedure and extended Stored Procedure  , I did some re-search but still can not get the right difference.

Please explain is simple terms.

Answer 1

Hello,

Stored procedures are written in plain Transact SQL (or as a .NET CLR) and stored in database, while XP are writen in unmanaged code like C++ and store in file system.

See Creating Extended Stored Procedures

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Here you go!

http://www.nullskull.com/q/10014003/tell-me-the-difference-between-stored-procedure-and-extended-stored-procedure.aspx

https://stackoverflow.com/questions/3055975/difference-between-stored-procedures-and-extended-stored-procedures

hope this helps!

---

Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

Answer 3

Check this too..

http://www.informit.com/articles/article.aspx?p=25288&seqNum=7

https://www.sqlconfiguration.com/enterprise-issues-business-rules/module5/system-extended-stored-procedures.php#gsc.tab=0

Answer 4

In addition to the other posts: extended stored proceduers is an old and deprecated technology and you would rarely have reason to mess with them save for a handful that comes with SQL Server.

---

Erland Sommarskog, SQL Server MVP, [e-mail]