Post reply

sp_dropextendedproperty with triggers

  • February 15, 2011 at 7:17 am

    #231391

    Hi,

    Can't seem to find any documentation on this...

    When I try to use the sp_dropextendedproperty with a trigger, eg:

    EXEC sp_addextendedproperty 'Version','5.2', 'schema', 'dbo', 'trigger', 'D_TriggerForViews', NULL, NULL

    It returns the error:

    Msg 15600, Level 16, State 5, Procedure sp_addextendedproperty, Line 37

    An invalid parameter or option was specified for procedure 'sp_addextendedproperty'.

    So...can you have extended properties for triggers at all? Or maybe SQL Server considers them procedures? Anyone know?

  • February 15, 2011 at 7:30 am

    #1287063

    meh, nevermind think I got a semi-explanation here:

    http://msdn.microsoft.com/en-us/library/ms180047.aspx

  • February 15, 2011 at 7:43 am

    #1287078

    In case anyone else has this problem as searches for it:

    A trigger is a "level 3" object, beneath a table (for example). So you specify the schema, then the table, then the trigger - like a column. 3 "levels" of parameters.

Viewing 3 posts - 1 through 2 (of 2 total)

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