Unfortunatelly i couldn't resolve the https issue but for http here is my script:

USE[redb]

go

-- CLEANUP

DROP FUNCTION [dbo].[ufnCalcBusinessDays]

DROP ASSEMBLY [REDB.XmlSerializers]

DROP ASSEMBLY [REDB]

-- Create Assembly

ALTER DATABASE REDB SET TRUSTWORTHY ON

CREATE ASSEMBLY REDB...

You can buy this book which is a good reference for learning CLR.

"Professional SQL Server 2005 CLR Programming with Stored Procedures, Functions, riggers, Aggregates, and Types" from the "Wrox".

Authors: Derek...

As i check the SSIS_Config view, it doesn't support both environments (Development and UAT) to coexist on the same machine. Is there any solution to support this?

One more question. I have two databases one for the Test and the other for UAT on the same machine. In which database, do i have to store the SSIS_Config...