easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DR - 24 Oct 2007 23:00 GMT

easiest way to upload a C# class library to a SQL server 2005 and deploy as
CLR function

Do I have to upload the .dll and then run sql command to load it into sql
server, or is there a more integrated way to do this in visual studio 2005
with a SQL Server Project? or do i have to manualu upload the DLL in all
cases? Any tutorial on CLR with Visual Studio 2005 IDE to Sql Server 2005?

Reply to this Message

Henning Krause [MVP - Exchange] - 25 Oct 2007 06:25 GMT

Hello,

if you are working with a Visual Studio Solution and have the Project
Template for SQL Server Projects installed, you can just hit "Deploy" in the
Build menu.

Kind regards,
Henning Krause

> easiest way to upload a C# class library to a SQL server 2005 and deploy
> as CLR function
[quoted text clipped - 3 lines]
> with a SQL Server Project? or do i have to manualu upload the DLL in all
> cases? Any tutorial on CLR with Visual Studio 2005 IDE to Sql Server 2005?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...