How To Create Extended Stored Procedure? RRS feed

  • Question

  • Hey
    I have to right an Extended Stored procedure using SQLDMO DLL to generate scripts,restore database etc..

    I have a VB script which does the similar thing as below
    How can I do it using extended stored proc
    i was told to not to use Extended Stored procedure before in the forum but i have to use it ........

    pls help me....i dont have any idea how to use Extended Stored procedure..
    Monday, June 8, 2009 5:26 PM


  • Why create an extended stored procedure ? You can use the SMO dlls as well to do all the stuff DMO does (plus additional things). DMO is deprecated and no further development should be based on this.

    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    • Marked as answer by user19 Monday, June 8, 2009 8:19 PM
    Monday, June 8, 2009 7:19 PM