Microsoft KB Archive/198851

= INF: User Cannot Bind Rule to UDDT Created By Different User =

Article ID: 198851

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q198851



SUMMARY
If a user (this also includes the system administrator [sa]) tries to bind a rule to a user-defined data type (UDDT) that was created by a different user, the following error message occurs:

You do not own a data type with that name.



MORE INFORMATION
This behavior is correct and by design. As per SQL Server Books Online, permission to run the sp_bindrule stored procedure on an object, defaults to the owner of that object.

WORKAROUND
To workaround this behavior, use CHECK constraints instead of Rules.

Note that the use of CHECK constraints is the preferred way to restrict the values in a column because CHECK constraints are more concise than Rules. You can only apply one rule to a column, but you can apply multiple CHECK constraints to a column.

Additional query words: sp_bindrule data type

Keywords: kbinfo KB198851

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.