Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> .NET Framework inside SQL Server

How do I reference an external assembly?

I have a situation where I need to use external .NET assemblies, including interop assemblies, from within a SQL CLR stored procedure. I assumed that if my assembly is registered as "unsafe" that I could reference what I need in my SQL Server project. However, VS 2005 will only allow me to add references to SQL libraries, or projects in the same solution which are themselves SQL Server projects.

So, how can I reference external assemblies from my SQL Server project? Any advice at all is welcome. Thanks!

[510 byte] By [JeffStephens] at [2008-2-10]
«« Performing Search from database and showing result on same form in VB.NET & SQL envirnment
»» Shouldn't this exception logged as error or warning in event log
# 1
You need to register all the assemblies that you want to reference in your code in the SQL Server database and then they will appear in the 'SQL Catalog' (SQL Server tab in add references) in Visual Studio and you will be able to add reference to them.

Thanks,
-Vineet.

VineetRao-Microsoft at 2007-9-9 > top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...
SQL Server
.NET Framework inside SQL Server

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified