I have a SQL CLR project which creates a SQL user defined function. I want to reference this project in another SQL Server 2005 database project. According to msdn documentation http://msdn.microsoft.com/en-us/library/dd193408.aspx
they say under the section "Use the Type Defined in the SQLCLR Assembly" to basically Add Reference to the CLR project. But actually in a SQL server 2005 database projects Reference section has only one option - "Add Database Reference". Has anyone faced this problem and how did you overcome it?