Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Error message when you use the CREATE ASSEMBLY statement in Visual Studio 2005 Team Edition for Database Professionals "CREATE ASSEMBLY statement can only have binary elements in its FROM clause"
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: