This article has been archived. It is offered "as is" and will no longer be updated.
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 file
Use a binary representation of the file in the CREATE ASSEMBLY statement. For example, use code that resembles the following code example.