SQL Server 2005 introduced CLR integration, allowing users to create assemblies using .NET code. This was a major new feature that enabled stored procedures, functions, triggers, and types to be written in C#, VB.NET, or other .NET languages. The CREATE ASSEMBLY statement is used for this purpose.