sql server - Two versions of assembly

Posted on 2010-08-25
Medium Priority
Last Modified: 2012-05-10
I execute this query
use myDatabaseTest
--Crear el Assembly
create assembly ConvertDecimalToString
 from 'D:\6232\Utilities.dll'
it is OK

Run the same code but using another database and got error of the following information
use AdventureWorks
--Crear el Assembly
create assembly ConvertDecimalToString
 from 'D:\6232\Utilities.dll'
I have this error
Msg 10326, Level 16, State 2, Line 3
Two versions of assembly 'utilities, version=, culture=neutral, publickeytoken=null, processorarchitecture=msil' cannot coexist in database 'AdventureWorks'. Keep one version and drop the other.

The problem is that there is already a dll with that name, as I can do to create the assembly without removing the existing ones.
Question by:enrique_aeo

Expert Comment

ID: 33527572
You already have created assembly, why do you what to create it twice?
LVL 12

Accepted Solution

Nirmalan Nagenthiran earned 2000 total points
ID: 33527963

Author Comment

ID: 33533231
Two people from different companies I have given each its assembly and coincidentally have the same name

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question