manavsm -6 Light Poster

How can you create standard UDDs across all new databases ?

Actually i want to create user defined datatypes across all the databases . I am using MS SQL 2000. I want the ans through query only.

Below is my code for creating UDD-

sp_addtype gender_rule,'char(10)','not null'

Now i want to use the datatype across all my database . Like for example

create table user_defined(
sex gender_rule,
eno int)

If i create the above datatype i can only use it in the current database.
Plz advice