CLR sql server2008

alter database ScolastanceDevMathis_Jerome set trustworthy on
go
--GRANT EXTERNAL ACCESS ASSEMBLY TO [scolastance]
GRANT unsafe ASSEMBLY TO [scolastance]
go


---------------------------------------------------------------

drop function dbo.fn_Arrondi;
drop assembly CalculNote
CREATE ASSEMBLY CalculNote
from 'd:\ArrondiNote\dll\CalculNote.dll'
WITH PERMISSION_SET = UNSAFE
go
CREATE function dbo.fn_Arrondi( @laNote decimal(10,5),@laPrecision decimal(10,5),@lArrondi nvarchar(4),@OptMoySupDenom bit )
returns decimal
AS
EXTERNAL NAME CalculNote.Arrondi.arrondiNote
GO