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