EXEC sp_configure 'show advanced options' , '1';
reconfigure;
EXEC sp_configure 'clr enabled' , '1' ;
reconfigure;
EXEC sp_configure 'show advanced options' , '0';
reconfigure;
USE msdb
GO
--Note:  if necessary, change the path to the location where the NbtSendMail.dll was copied.
-- CREATE ASSEMBLY NBTSendMail FROM 'C:\Programme\New Boundary\Server\NbtSendMail\NBTSendMail.dll' 

CREATE ASSEMBLY NBTSendMail FROM 'C:\Program Files (x86)\New Boundary\Server\NbtSendMail\NBTSendMail.dll' 
WITH PERMISSION_SET = UNSAFE 
GO
CREATE PROCEDURE [dbo].[pr_NBTSendMail]
   @server [nvarchar](128),
   @port [int],
   @timeout [int],
   @enableSSL [int],
   @serverUser [nvarchar](128),
   @serverPass [nvarchar](128),
   @recipients [nvarchar](4000),
   @subject [nvarchar](4000),
   @from [nvarchar](4000),
   @body [nvarchar](4000)
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [NBTSendMail].[NBTsproc].[pr_NBTSendMail]
GO
CREATE FUNCTION [dbo].[pf_NBTEncryptPassword]  
   (@password [nchar](20)) RETURNS nchar(128)
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [NBTSendMail].[NBTudf].[pf_NBTEncryptPassword]
GO