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.