Article ID: 928961 - View products that this article applies to.
Consider the following scenario. In Microsoft Visual Studio 2005 Team Edition for Database Professionals, you create a new database project. In the database project, you use the CREATE ASSEMBLY statement to add a common language runtime (CLR) assembly to the project. You use a file path to reference the CLR assembly.
In this scenario, you may receive an error message that resembles the following:
TSD3009: CREATE ASSEMBLY statement can only have binary elements in its FROM clause.
To work around this issue, use one of the following methods.
Method 1: Use a binary representation of the fileUse a binary representation of the file in the CREATE ASSEMBLY statement. For example, use code that resembles the following code example.
Method 2: Deploy to a test serverIf you must include the database project in a solution that also includes a server project, deploy the server project to a test server. After you deploy the server project, follow these steps:
Steps to reproduce the behavior
For more information about the CREATE ASSEMBLY statement, visit the following Microsoft Developer Network (MSDN) Web site:
Contact us for more help
Connect with Answer Desk for expert help.