Difference between Stored Procedure and extended Stored Procedure RRS feed

  • 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.

    Wednesday, August 8, 2018 11:18 AM


  • 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]

    • Proposed as answer by pituachMVP Wednesday, August 8, 2018 1:24 PM
    • Marked as answer by MU DBA Friday, August 17, 2018 2:28 AM
    Wednesday, August 8, 2018 11:26 AM

All replies