locked
extended stored procedure RRS feed

  • Question

  • what is an extended stored procedure? Can you instantiate a com object by using T-SQL?

     

    Thanks...

    Friday, January 13, 2012 1:59 AM

Answers

  • Extended stored procedures allow you to create your own external routines in a programming language such as C. The extended stored procedures appear to users as normal stored procedures and are executed in the same way. Parameters can be passed to extended stored procedures, and they can return results and return status. Extended stored procedures can be used to extend the capabilities of Microsoft® SQL Server™ 2000.

    http://msdn.microsoft.com/en-us/library/aa214418%28v=sql.80%29.aspx

    Extended stored procedures are deprecated now.
    You should use CLR Integration instead.

    • Proposed as answer by Naomi N Friday, January 13, 2012 2:23 AM
    • Marked as answer by Kalman Toth Wednesday, January 18, 2012 6:27 PM
    Friday, January 13, 2012 2:09 AM
  • Extended stored procedures allow you to call any function within a C or C++ DLL.  Pretty hairy stuff if you don't seriously need it.  See http://support.microsoft.com/kb/190987

    As for instantiating / calling COM objects, see this article http://www.sqlteam.com/article/calling-com-objects-from-t-sql

    • Proposed as answer by Naomi N Friday, January 13, 2012 2:23 AM
    • Marked as answer by Kalman Toth Wednesday, January 18, 2012 6:27 PM
    Friday, January 13, 2012 2:09 AM

All replies

  • Extended stored procedures allow you to create your own external routines in a programming language such as C. The extended stored procedures appear to users as normal stored procedures and are executed in the same way. Parameters can be passed to extended stored procedures, and they can return results and return status. Extended stored procedures can be used to extend the capabilities of Microsoft® SQL Server™ 2000.

    http://msdn.microsoft.com/en-us/library/aa214418%28v=sql.80%29.aspx

    Extended stored procedures are deprecated now.
    You should use CLR Integration instead.

    • Proposed as answer by Naomi N Friday, January 13, 2012 2:23 AM
    • Marked as answer by Kalman Toth Wednesday, January 18, 2012 6:27 PM
    Friday, January 13, 2012 2:09 AM
  • Extended stored procedures allow you to call any function within a C or C++ DLL.  Pretty hairy stuff if you don't seriously need it.  See http://support.microsoft.com/kb/190987

    As for instantiating / calling COM objects, see this article http://www.sqlteam.com/article/calling-com-objects-from-t-sql

    • Proposed as answer by Naomi N Friday, January 13, 2012 2:23 AM
    • Marked as answer by Kalman Toth Wednesday, January 18, 2012 6:27 PM
    Friday, January 13, 2012 2:09 AM
  • The Microsoft Extended Stored Procedure API provides a server-based application programming interface (API) for extending Microsoft SQL Server functionality. The API consists of C and C++ functions and macros used to build applications in the following categories: extended stored procedures and gateway applications.

    This link might prove to be useful to you - http://www.edbarlow.com/gem/procs_only/index.htm


    -Vinay Pugalia
    If a post answers your question, please click "Mark As Answer" on that post or "Vote as Helpful".
    Web : Inkey Solutions
    Blog : My Blog
    Email : Vinay Pugalia

    Friday, January 13, 2012 4:49 AM