USE pubs
GO

-- fred should already be in the database

--
-- create an assembly owned by sysadmin
--
CREATE ASSEMBLY SomeTypes
authorization fred
FROM 'c:\temp\TestConfigLib.dll'
GO


-- create an assembly owned by DBO
CREATE ASSEMBLY SomeMoreTypes
AUTHORIZATION dbo
FROM '\types\SomeMoreTypes.dll'
GO

-- if one assembly calls another, they 
-- need to be owned by the same user
-- alter the first assembly to be owned by DBO
ALTER authorization on assembly::SomeTypes TO dbo