Extended stored procedure?

Discussion in 'microsoft.public.sqlserver.programming' started by Ray5531, Apr 29, 2005.

  1. Ray5531

    Ray5531 Guest

    I noticed that there is something in master database called
    Extended stored procedure which can be dlls? what's this? How can we make
    our own sps a dll and put it somewhere like this?



    Thanks
     
    Ray5531, Apr 29, 2005
    #1
    1. Advertisements

  2. Ray5531

    Michael C# Guest

    1. Advertisements

  3. Ray5531

    oj Guest

    oj, Apr 29, 2005
    #3
  4. Ray5531

    Ray5531 Guest

    Do they really have to be in Master Database only?
    I don't know C++,is there another way of making an extended sp? like using
    C#?

    Thanks
     
    Ray5531, Apr 29, 2005
    #4
  5. Ray5531

    Michael C# Guest

    Not in managed code, no. AFAIK, SQL 2K5 will allow hosting of managed code.
    I would either: 1) Write whatever you're trying to do as an external app and
    run it separately from SQL Server, or 2) Wait for SQL 2K5.
     
    Michael C#, Apr 29, 2005
    #5
  6. Ray5531

    Ray5531 Guest

    Can I write my own sps as dlls in 2005 with managed code ?

    Thanks
     
    Ray5531, Apr 29, 2005
    #6
  7. Do they really have to be in Master Database only?

    Yes.

    Not managed code. Not classic VB (as it creates COM DLLs, not classic DLLs). Only C, C++ or Delphi.

    Another option is to write a COM object and use SP_OACreate etc. to use that COM object.
     
    Tibor Karaszi, Apr 29, 2005
    #7
  8. Ray5531

    Michael C# Guest

    Michael C#, Apr 29, 2005
    #8
  9. Ray5531

    oj Guest

    oj, Apr 29, 2005
    #9
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.