Strange problem with extended property

• Jonas Karlsson

  Newbie

  Points: 1

  More actions

  January 16, 2005 at 10:47 pm

  #65509

  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

  ALTER TABLE T1

  WITH NOCHECK

  ADD CONSTRAINT constraint1

  CHECK (

  col2 IS NULL

  OR

  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

• January 19, 2005 at 8:00 am

  This was removed by the editor as SPAM