Saturday, February 2, 2008

Using CLR Integration in SQL Server 2005

Enabling CLR on sql server 2005 command :
EXEC sp_configure @configname = ’clr enabled’, @configvalue = 1
RECONFIGURE WITH OVERRIDE

Discussion on CLR Integration in SQL Server 2005 benefits and alternatives
http://msdn2.microsoft.com/en-us/library/ms345136.aspx

An Intro to CLR Integration in SQL Server 2005 By Sahil Malik
http://www.developer.com/net/net/article.php/3528601

Simple SQL CLR Integration By Amit Anajwala : Simple how to for begginers
http://www.sqlservercentral.com/articles/Development/simplesqlclrintegration/2023/

Using CLR Integration in SQL 05 for Writing Stored Procedures By Jesse Smith.
http://www.informit.com/articles/article.aspx?p=715008


Series of articles on developer.com By Sahil Malik

1. Writing Database Objects in CLR
http://www.developer.com/net/net/article.php/3548331

2. Writing Database Objects in CLR: Advanced Scenarios
http://www.developer.com/net/net/article.php/3550341

3. Solving the Mysteries of SQLCLR and System.Transactions
http://www.developer.com/net/net/article.php/3556571

No comments: