Answer: User-defined data types can be used when several tables must store the same type of data in a column and you must ensure that these columns have exactly the same data type, length, and nullability.
For more details, visit
http://msdn.microsoft.com/en-us/library/aa933121(SQL.80).aspx
Thanks