Strange problem with extended property

  • Hello,

    I have a problem with extended property MS_ConstraintText. MS_ConstraintText property is not shown to other end users except for my own login (which have created the extended property). Another extended property, caption, is displayd correctly for all users.

    Here is example code:


    CREATE table T1 (

    id int identity not null primary key nonclustered ,

    col2 int)

    EXEC sp_addextendedproperty

    'caption', 'Employee ID',

    'user', dbo,

    'table', 'T1',

    'column', id



    ADD CONSTRAINT constraint1

    CHECK (

    col2 IS NULL


    col2 >= 0


    EXEC sp_addextendedproperty

    'MS_ConstraintText', 'test.',

    'user', dbo,

    'table', 'T1',

    'constraint', constraint1


    SQL Server 2000 SP3, Access XP (Access 2002 file format).

    So, the caption extended property works for all users and the MS_ConstraintText only works for my own user login.

    I want to display customized error messages to end user when a constraint are not fulfilled.

    Does anybody have an idea to solv the problem?

    /Jonas Karlsson

  • This was removed by the editor as SPAM

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

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