user defined type as a primary key

[umeshpotdar]

hi frdz
i have created user defined types in sql server 2005
i want to use these types as a primary key in my table
but i got error when i assign primary key to it
(error ----- Primary key can not be exceed 900 bytes)
so what should i do for that
i must have to use it
so can anybody tell me
plz. ........

[iburyak]

I already saw this question and it is a server limitation that can’t be overcome.

Think of creating some integer column along with UserDfined and use that as a primary key. On column with UserDefined datatype just put Unique index instead to prevent duplicates.


Good Luck.