Contraint validation text not showing when user not in sys admin role

From: Benjamin Huang (huang_bingjun@hotmail.com)
Date: 07/18/02 

From: "Benjamin Huang" <huang_bingjun@hotmail.com>
Date: Thu, 18 Jul 2002 07:07:24 -0700

I have an MS Access adp file (2000 format) with backend on
W2K/SQL2K. I created an check constraint on one of
columns. Access adp has the capability to create
personalized validation text for that check constraint,
which I did. The problem is that when the user is in sys
admin role, the personalized validation text shows
whenever the check constraint is violated. However, if the
user is not in sys admin role, the regular SQL server
error message shows up instead of the personalized error
message. I even tried to put the user in dbo, it still
doesn't work.

MS says that the capability Access Adp has is using
extended properties of SQL sever. I tried
using "::fn_lstextendproperty", but it didn't show
anything I created. I finally find that the validation
text was stored in the [sysproperties] table of the user
database. The property name is [MS_ConstrainText].

Does any one know how to show the personalized validation
text without put user in the sys admin role. Thanks.