Where do I find user defined data types in a database if they exist?

Launch SQL Server Management Studio (herein Microsoft SQL Server Management Studio    Version:13.0.15600.2)

In the databases node identify the database. Under Programmability you will find the Types node. Types node has all the types including User-defined type as shown here:

USERdEFINEDdATATYPE_00

Just to see what is required in creating a new User-Defined type right click one of them and look at its properties as showon for the user defined data type called OrderNumber shown here:

USERdEFINEDdATATYPE_02   

You can also define a default and rule. User-defined data types can also be created using T-SQL.

Once it is created you can use it in creating a table as shown here. The data-type will be available in the drop-down to choose.

            

How do I attach a database to a SQL Server?

Very simple.

 You can do it in the SQL Server Management Studio (SSMS) or use System Stored Procedures.

You can see a step by step method at this link here.
http://hodentekmsss.blogspot.com/2010/05/using-sample-databases-with-sql-server.html

Moving from SQL Server 2000 to 2005 read here:
http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/3/ [about 0.5 million page views]