CLR - Run a managed code on a client computer

Question

CLR - Run a managed code on a client computer

ichacmoll

Mr or Mrs. 500

Points: 554
More actions
June 29, 2011 at 12:31 pm

#243557

I was reading an article from MSDN which says that a stored procedure created with managed code can run on a client computer, I've been looking for several sites in the MSDN and the web and have not found how to achieve it, I hope some of you may guide me or give me a reference where I can achieve this, thanks for your kind attention.
Regards.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

ChacMoll (6/29/2011)
I was reading an article from MSDN which says that a stored procedure created with managed code can run on a client computer, I've been looking for several sites in the MSDN and the web and have not found how to achieve it, I hope some of you may guide me or give me a reference where I can achieve this, thanks for your kind attention.
Regards.

The section in question:

Choosing Between Execution in the Server and Execution in the Client
Another factor in your decision about whether to use Transact-SQL or managed code is where you would like your code to reside, the server computer or the client computer. Both Transact-SQL and managed code can be run on the server. This places code and data close together, and allows you to take advantage of the processing power of the server. On the other hand, you may wish to avoid placing processor intensive tasks on your database server. Most client computers today are very powerful, and you may wish to take advantage of this processing power by placing as much code as possible on the client. Managed code can run on a client computer, while Transact-SQL cannot.

This is talking about managed code in general. Examples would be a Windows Console App or a Windows Forms App written in C#. It is poorly worded IMO but they are not implying that managed code written for and hosted inside a SQL Server database can be executed on a client computer.

The conversation is more towards where to put your application code, i.e. the separation of responsibilities.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 2

I agree with opc.three's read on your question, SQLCLR code is always run on the machine running SQL Server. What you can do is something related to Service Broker called "External Activation" where you can trigger code external to the database, you cannot really call it directly but you can cause it to be triggered. I know .

See this url: http://msdn.microsoft.com/en-us/library/ms171617.aspx

CEWII

ichacmoll Mr or Mrs. 500 Points: 554 More actions · Answer 3

Thank you very much!

You are right, indeed this was a problem of understanding in my reading, but I'm interested to support me if you know of any technology or method (other than an App) that allows me to exploit the resources of the client in terms of access to the database.

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 4

ChacMoll (6/29/2011)
Thank you very much!
You are right, indeed this was a problem of understanding in my reading, but I'm interested to support me if you know of any technology or method (other than an App) that allows me to exploit the resources of the client in terms of access to the database.

Not to my knowledge. RDBMS platforms are typically server/client, not distributed. What is motivating these questions? What are you trying to do?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato