All,

After some serious tries on this, after updating the SQL server with latest framework, I recompiled the DLL used by my CLR and simple ran this statement: 
ALTER...

Functions are good unfortunately I only have a SQL 2005 at this time so the Date variable type is not available to me.

Thanks for the responses. Mine works as...

Grrr my email blocker blocked all of my notifications. I didn't see the responses.

Thanks for the responses guys. I shall check it out and write back.

Cool. Thanks for the information. I have checked out these tools and they seem very good.

Basically I don’t have a DBA. We build asp.net apps and constantly change stored...