SQL Server – How to create an assembly in SQL Server that references a .DLL file – SQL Circuit

SQL Server – How to create an assembly in SQL Server that references a .DLL file

CREATE ASSEMBLY uploads an assembly from  .dll file to use inside an instance of SQL
Server. Below is the code mentioning how to create an assembly in SQL Server
instance that references a .DLL file:

IF  EXISTS (SELECT * FROM sys.assemblies ASM WHERE ASM.name = N’EmailSubscriptionAssembly’
AND ASM.is_user_defined
= 1)
DROP ASSEMBLY
[SendEMailNotificationAssembly]
GO
CREATE ASSEMBLY
EmailSubscriptionAssembly FROM ‘G:MyApplication_DLLEmailSubscription.dll’
WITH PERMISSION_SET = External_Access;

 

Related Posts

SQL Server Case Sensitivity

SQL Server is, by default, case insensitive, which means the word “SQL SERVER” or “sql server” will be same for…

Leave a Reply

Your email address will not be published. Required fields are marked *