How to: Deploy SQL Server Project Items in Referenced Assemblies
SQL Server project items in referenced assemblies cannot be deployed using the deployment features in Visual Studio; use the Transact-SQL Create Assembly statement instead. For example, if one SQL Server project contains a reference to another SQL Server project, you cannot use the deploy command in the first project to deploy the items in the second (referenced) project.
The common language runtime (CLR) integration feature is off by default in Microsoft SQL Server and must be enabled in order to use SQL Server project items. To enable CLR integration, use the clr enabled option of the sp_configure stored procedure. From more information, see.
To deploy SQL Server project items in referenced assemblies
Build the items in your project, a well as any items that need to be built in the referenced assembly.
Deploy the items using the Transact-SQL Create Assembly statement passing in the information for the dll you want to deploy to the SQL Server. For more information, see thetopic in the SQL Books Online.