Registering additional assemblies in SQL CLR

By default not all assemblies are included for the CLR to use with. To add other assemblies,

ALTER DATABASE AdventureWorks SET TRUSTWORTHY ON

CREATE ASSEMBLY Messaging
AUTHORIZATION dbo
FROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Messaging.dll'
WITH PERMISSION_SET = UNSAFE