[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1673
  • Last Modified:

sql server - Two versions of assembly

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
enrique_aeo
Asked:
enrique_aeo
1 Solution
 
marat-ozCommented:
You already have created assembly, why do you what to create it twice?
0
 
Nirmalan NagenthiranCommented:
0
 
enrique_aeoAuthor Commented:
Two people from different companies I have given each its assembly and coincidentally have the same name
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now