You could create CLR data types using Visual Studio and import them into SQL Server 2005. CLR user-defined types are like .NET objects that can be used to store data in SQL Server.

Try the following links:

• http://msdn.microsoft.com/en-us/library/ms186366.aspx
• http://msdn.microsoft.com/en-us/library/ms131120.aspx

Gogula G. Aryalingam (MVP - SQL Server)