Results 1 to 3 of 3

Thread: Help ::: Extended Properties

  1. #1
    Mariah Guest

    Help ::: Extended Properties

    Hi all,

    Plz help me to know whats wrong with following script:

    EXEC sp_addextendedproperty
    @name = 'col_Programs_ID_Description',
    @Value = 'The Unique Identifier for a specific Program',
    @level1Type = 'Programs',
    @level2Type = 'ID'

    I get the following error:
    Server: Msg 15600, Level 15, State 1, Procedure sp_addextendedproperty, Line 42
    An invalid parameter or option was specified for procedure 'sp_addextendedproperty'.

    NOTE: If I dont use the last 2 parameters this procedure runs fine, but it adds the Extended Property to the Database Level while I'm trying to add it to the TABLE-->COLUMN level.

    Thanks
    Mariah

  2. #2
    Mohammed. Guest

    Help ::: Extended Properties (reply)

    YOu are passing the invalid input to the last two parameters...
    @level1Type = 'Programs',
    @level2Type = 'ID'
    See the following info... you can fine this in BOL too....

    [ @level1type = ] { 'level1_object_type' }
    Is the type of level 1 object. level1_object_type is varchar(128), with a default of NULL. Valid inputs are TABLE, VIEW, PROCEDURE, FUNCTION, DEFAULT, RULE, and NULL.
    [ @level2type = ] { 'level2_object_type' }
    Is the type of level 2 object. level2_object_type is varchar(128), with a default of NULL. Valid inputs are COLUMN, PARAMETER, INDEX, CONSTRAINT, TRIGGER, and NULL



    ------------
    Mariah at 8/15/2002 5:43:49 AM

    Hi all,

    Plz help me to know whats wrong with following script:

    EXEC sp_addextendedproperty
    @name = 'col_Programs_ID_Description',
    @Value = 'The Unique Identifier for a specific Program',
    @level1Type = 'Programs',
    @level2Type = 'ID'

    I get the following error:
    Server: Msg 15600, Level 15, State 1, Procedure sp_addextendedproperty, Line 42
    An invalid parameter or option was specified for procedure 'sp_addextendedproperty'.

    NOTE: If I dont use the last 2 parameters this procedure runs fine, but it adds the Extended Property to the Database Level while I'm trying to add it to the TABLE-->COLUMN level.

    Thanks
    Mariah

  3. #3
    Mariah Guest

    Help ::: Extended Properties (reply)


    hi,

    Thanks my friend, it really helped me a lot.

    Regards,
    Mariah


    ------------
    Mohammed. at 8/15/2002 6:27:41 PM

    YOu are passing the invalid input to the last two parameters...
    @level1Type = 'Programs',
    @level2Type = 'ID'
    See the following info... you can fine this in BOL too....

    [ @level1type = ] { 'level1_object_type' }
    Is the type of level 1 object. level1_object_type is varchar(128), with a default of NULL. Valid inputs are TABLE, VIEW, PROCEDURE, FUNCTION, DEFAULT, RULE, and NULL.
    [ @level2type = ] { 'level2_object_type' }
    Is the type of level 2 object. level2_object_type is varchar(128), with a default of NULL. Valid inputs are COLUMN, PARAMETER, INDEX, CONSTRAINT, TRIGGER, and NULL



    ------------
    Mariah at 8/15/2002 5:43:49 AM

    Hi all,

    Plz help me to know whats wrong with following script:

    EXEC sp_addextendedproperty
    @name = 'col_Programs_ID_Description',
    @Value = 'The Unique Identifier for a specific Program',
    @level1Type = 'Programs',
    @level2Type = 'ID'

    I get the following error:
    Server: Msg 15600, Level 15, State 1, Procedure sp_addextendedproperty, Line 42
    An invalid parameter or option was specified for procedure 'sp_addextendedproperty'.

    NOTE: If I dont use the last 2 parameters this procedure runs fine, but it adds the Extended Property to the Database Level while I'm trying to add it to the TABLE-->COLUMN level.

    Thanks
    Mariah

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •