Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jonaskarlsson
Starting Member
2 Posts |
 Posted - 2005-01-14 : 05:23:20
|
| 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', idALTER TABLE T1WITH NOCHECKADD CONSTRAINT constraint1CHECK (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 cusomized error messages to end user when a constraint are not fulfilled.Does anybody have an idea to solv the problem?/Jonas Karlsson |
|
|
|
|
|
|
|
Problem: Extended property used in Access adp proj