Enable CLR in SQL Server 2005 - SQL Server 2005 Tutorials

I have mentioned how to enable CLR in SQL Server 2005 in several SQL Server 2005 Tutorials, but I thought I would just put it in its own post just so people can find it easier:

 

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

 

Filed: SQL Server 2005, Source: David Hayden

SQL Server 2005 Tutorials

• Http Endpoint and FOR XML - Return XmlElement in Native XML WebServices in SQL Server 2005
• Creating XML Schema from XML Data using Visual Studio 2005
• XML Data Type XQuery XML Indexes XML Schema Collection and Http Endpoints in SQL Server 2005
• SQLCLR - Create CLR User-Defined Function ( UDF ) - Check Constraint on EmailAddress Column Using RegEx
• Web Services and SQL Server 2005 - sqlbatch - HTTP Endpoint - BATCHES = ENABLED
• Native XML Web Services in SQL Server 2005 - Creating HTTP Endpoints - Native HTTP
• SQL Server 2005 XML Web Services - Create HTTP Endpoint Using SMO
• XML Data Type in SQL Server 2005 - Part I
• SQL Server Management Objects

 

posted on Tuesday, April 25, 2006 12:01 AM