A user-defined datatype must be created in each database in which it will be used. It is a good practice to create frequently used types in the model database. These types are automatically added to each new database (including tempdb, which is used for temporary tables) as it is created.
