use adventureworks
go

-- create the assembly
CREATE ASSEMBLY 

-- drop the assembly
DROP ASSEMBLY 

-- attempt create assembly with a different name
CREATE ASSEMBLY 

-- attempt create assembly with a different case
CREATE ASSEMBLY 

-- define a managed user-defined function
CREATE FUNCTION KilogramsToPounds

-- use it in T-SQL



-- drop it
DROP FUNCTION KilogramsToPounds
go

-- attempt create function with a different case
CREATE FUNCTION KilogramsToPounds 