<div>
<a href="http://stackoverflow.com/questions/439859/advantage-of-sql-server-clr" rel="ugc">http://stackoverflow.com/questions/439859/advantage-of-sql-server-clr</a><br />
<a href="http://msdn.microsoft.com/en-us/library/k2e1fb36(VS.80).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/k2e1fb36(VS.80).aspx</a>
</div>


http://stackoverflow.com/questions/439859/advantage-of-sql-server-clr [http://stackoverflow.com/questions/439859/advantage-of-sql-server-clr]
http://msdn.microsoft.com/en-us/library/k2e1fb36(VS.80).aspx [http://msdn.microsoft.com/en-us/library/k2e1fb36(VS.80).aspx]

<div>
@lucky85:<br />
<br />
That all sounds fine for advantages but I'm looking for real world experience. &nbsp;<br />
<br />
There isn't much out there on issues with deploying and debugging an sql clr. &nbsp;But I have read some about those issues and it gets very time consuming for little return. &nbsp;I'd would like to know more about those issues.<br />
<br />
@Marcjev:<br />
<br />
I read that. &nbsp;Seems like you will run into the regular hurdles with debugging on a remote machine in .NET, which is sometimes impossible on a corp network.
</div>


@lucky85:

That all sounds fine for advantages but I'm looking for real world experience.  

There isn't much out there on issues with deploying and debugging an sql clr.  But I have read some about those issues and it gets very time consuming for little return.  I'd would like to know more about those issues.

@Marcjev:

I read that.  Seems like you will run into the regular hurdles with debugging on a remote machine in .NET, which is sometimes impossible on a corp network.

<div>
<div class="content wysiwyg-content">
In regards to debugging and deploying a .NET SQL CLR assembly, I'd like to hear comments about experiences or any links that discuss advantages/disadvantages.
</div>
</div>


In regards to debugging and deploying a .NET SQL CLR assembly, I'd like to hear comments about experiences or any links that discuss advantages/disadvantages.

.NET SQL CLR advantages/disadvantages?

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.