Re: SQL Server 2005 CLR Programming and Deployment

Tech-Archive recommends: Speed Up your PC by fixing your registry


Hi,

From BOL: http://msdn.microsoft.com/en-us/library/ms345099.aspx

----
Robert Lakinski


"Guy" <Guy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:25270953-DD5C-430F-A2E2-8B364C4ED8A7@xxxxxxxxxxxxxxxx
Thanks Uri Dimant.

Wow, way to much information for a CLR procedure that is only a few lines.

Can anyone condense all the above into a few lines of best practice?

Apologies for my ignorance.

Regards,
Guy

"Uri Dimant" wrote:

Hi
http://www.sqlclr.net/
http://www.sqlservercentral.com/columnists/yvarshal/creatingdotnetstoredproceduresinsqlserver2005.asp -
--CRL Stored Procedure
http://www.sqlskills.com/resources/Whitepapers/SQL%20Server%20DBA%20Guide%20to%20SQLCLR.htm -
--CRL SQL Server 2005
http://www.sqldbatips.com/showarticle.asp?ID=22 ----CLR
http://davidhayden.com/blog/dave/archive/2006/04/25/2924.aspx----CLR Stored
Procedure Calling External Web Service - SQL Server 2005


"Guy" <Guy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:168D3132-C7C0-474E-BAC1-9363C9B288EA@xxxxxxxxxxxxxxxx
> Hi All,
>
> Just written my first CLR routine a very simple routine based on an > MSDN
> Magazine article that implements Regular Expressions in SQL Server > 2005.
>
> The code all works fine. I have a scalar UDF function that returns true > or
> false depending on the input and regex pattern supplied, but I have a > few
> questions regarding deployment, and this is where my lack of experience
> really shows :-)
>
> How do I deploy the dll to customers that run our software?
>
> 1) Is there a preferred SQL Server 2005 folder to store the CLR dll?
> 2) What about supporting objects such as the assembly, and other
> components
> that are required for deployment, assuming the customer has a full SQL
> Server
> 2005 implementation installed?
>
> Please help the C# code is only a few lines, but not aware of all the
> files
> that I need to deploy to make it work.
>
> I am aware of the CREATE ASSEMBLY and CREATE FUNCTION scripts but won't > to
> follow best suggested practice in regard to where these components are
> installed.
>
> Your assistance appreciated.
>
> Kind Regards,
> Guy
>




.

Relevant Pages

  • Re: SQL Server 2005 CLR Programming and Deployment
    ... way to much information for a CLR procedure that is only a few lines. ... Procedure Calling External Web Service - SQL Server 2005 ... > How do I deploy the dll to customers that run our software? ... > Kind Regards, ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server 2005 CLR Programming and Deployment
    ... "Bob Beauchemin" wrote: ... way to much information for a CLR procedure that is only a few lines. ... Procedure Calling External Web Service - SQL Server 2005 ... How do I deploy the dll to customers that run our software? ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server 2005 CLR Programming and Deployment
    ... way to much information for a CLR procedure that is only a few lines. ... Procedure Calling External Web Service - SQL Server 2005 ... How do I deploy the dll to customers that run our software? ... Is there a preferred SQL Server 2005 folder to store the CLR dll? ...
    (microsoft.public.sqlserver.programming)
  • Re: Why cant recursive queries contain...?
    ... You need to recompile and add your assembly back into sqlserver. ... You can't pass parameters into the custom aggregates which means you need to write different custom aggregates where normally you would pass in a parameter. ... I think there are some advantages that could be realized by adding additional parameters to SQL CLR custom aggregates, and from what I understand that is on the radar for future versions of SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server 2005 - CLR Integration problem
    ... seems it's missing the 'CLR ENABLE', ... It shows how to create an external dll without using Visual Studio, ... MCITP SQL Server 2005 Database Administration All-in-One Exam ... >> already configured SQL Server Surface Area Configuration. ...
    (microsoft.public.cert.mcdba)