Register assemblies used in the SQL CLR stored procedure

Question

I worked with writing some stored procedures in .NET code using SQL CLR Integration. In a stored procedure, I call a third-party dll. When I try to create an assembly in SQL Server containing my own saved process, it complains that the third-party DLL is not registered in the database.

Is there a way to call a DLL without registering it with SQL Server?

Answer 1

No, you cannot use an assembly that is not in the list of approved assemblies or that is not registered in the database. You cannot even load it into the GAC to access it, it must be explicitly added to SQL Server using CREATE ASSEMBLY. Why don't you want to load the assembly into the database? What does he do in SQL? I ask because there may be another solution to your problem that is better suited.

Answer 2

The third build must be pre-deployed on the server. See this link for instructions on deploying the assembly to the server.