gistfile1.sql

IF EXISTS (SELECT * FROM sys.assembly_modules WHERE assembly_class='ConcateAll')    
BEGIN
    DROP AGGREGATE dbo.ConcateAll
END
IF EXISTS (SELECT * FROM sys.assemblies WHERE name='SQLCLR')    
BEGIN
	DROP ASSEMBLY [SQLCLR]
END