Solved

sql server - Two versions of assembly

Posted on 2010-08-25
3
1,496 Views
Last Modified: 2012-05-10
I execute this query
use myDatabaseTest
GO
--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
GO
--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=0.0.0.0, 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.
0
Comment
Question by:enrique_aeo
3 Comments
 
LVL 2

Expert Comment

by:marat-oz
Comment Utility
You already have created assembly, why do you what to create it twice?
0
 
LVL 12

Accepted Solution

by:
Nirmalan Nagenthiran earned 500 total points
Comment Utility
0
 

Author Comment

by:enrique_aeo
Comment Utility
Two people from different companies I have given each its assembly and coincidentally have the same name
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now