You can create a user-defined datatype with the identity property, using sp_addtype, but you must specify the identity property only for numeric datatypes with a scale of 0.
View this book as PDF