Post reply

Extended Stored Procedures question

  • December 6, 2004 at 9:54 am

    #91694

     

    I know Extended Stored Procedures are stored in the master database,

    I can access them from there, but does anyone know specifically

    what table they are stored in?

     

    thanks

     

  • December 6, 2004 at 10:57 am

    #532702

    Select * from master.dbo.sysobjects where XType = 'X'

  • December 6, 2004 at 11:05 am

    #532704

    Thanks, that's cool.

    There are other Xtypes in the sysobjects table, does anyone know what these are? They are D, FN, P, S, TF, U, V, X.

    Where do you find out nitty gritty stuff like this? My SQL book is pretty thick and it doesn't really go into this kind of detail.

     

    thanks.

     

  • December 6, 2004 at 11:12 am

    #532706

    Check in the books online under sysobjects / sysobjects

    C = Constraint CHECK

    D = Default value or DEFAULT constraint

    F = FOREIGN KEY Constraint

    FN = Scalar User defined function (returns interger or any variable)

    L = Log

    IF = Inline User defined function (A select query)

    P = Stored procedure

    PK = PRIMARY KEY CONSTRAINT

    RF = Replication Stored Procedure

    S = System table

    TF = Table function (returns a table variable)

    TR = Trigger

    UQ = Unique constraint

    V = View

    X = Extended stored procedure

  • December 6, 2004 at 1:27 pm

    #532749

    Extended stored procedures are not stored in any table. They are usually in a DLL file. You can find this out by running something like this:

    USE master

    GO

    EXEC sp_helpextendedproc 'xp_cmdshell'

    GO

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply