The answer is yes there are ways, the follow on question is why would you want to?

If all you are doing is selecting data, then you shouldn't be doing this in CLR. This is a TSQL only task. By using CLR for this, you are...

What is the error that you get, and what process are you doing when you get it? If it is a dependent items failure during a deploy operation, you...

You need to instatiate an instance of the Transaction Scope class. The following is an example of how you would do this:

using (TransactionScope ts = new TransactionScope())

{

using...

Matt is correct here. Unless you are doing complex regular expression replacements, your operation will likely be slower in CLR versus a set based TSQL implementation. I would...

I almost made a comment about offloading to Service Broker for exactly what RBarryYoung points out. You could hit latency issues on the linked server, but you could also...

This is not something that you should do with an assembly. A linked server can be created following the instructions in the BOL:

http://msdn.microsoft.com/en-us/library/ms190479.aspx

Then a DML Trigger on...

Just a note,

If I had to implement this, I would go the TSQL Route for the function over paying the cost of the CLR function in loading an AppDomain, and...

You can't change how it outputs the errors, but you can change how you consume them. For example, you can create a simple function to clean it up like:

...

What exactly is your application doing, and what is it written in? This kind of information is best implemented not in CLR but with standard DDL Triggers. The...

What type of CLR object is this? A Trigger/Stored Procedure?

More thn anything else, UDT's and UDF's are easily used out side of SQL. This is of great benefit for things like geocoding where the UDT is used as...

Akeelm,

Looking at your trigger, it has a common mistake that I see in both TSQL and CLR triggers. It only handles a single row, so if you have more...

Generally speaking this is accomplished with an Active Directory Domain Users Group. You add the AD Group to SQL Server as a Login, and then grant the correct rights...

(1) Create a new schema that will hold the SQLCLR objects

(2) Create an asymmetric key from the assembly dll

(3) Create a login from the asymmetric key

(4) Grant EXTERNAL-ACCESS-ASSEMBLY permissions to...