I am just started my journey in SQL Server 2005, and for a while I'm stuck because CLR is disable by default in my SQL Server 2005. Then I found this in google to enable CLR in SQL Server 2005:
EXEC
sp_configure 'show advanced options' , '1';
go
reconfigure
;
go
EXEC
sp_configure 'clr enabled' , '1'
go
reconfigure
;
-- Turn advanced options back off
EXEC sp_configure 'show advanced options' , '1';
go
From here, we can create User Define Types (UDF), User Define Function (UDF), Table value Functions (TVF), Triggers, and Stored Procedures using programming language such as VB.NET or C# and deploy it to our SQl Server.