Re: SQL Server 2005 - CLR Integration problem

seems it's missing the 'CLR ENABLE', 1 ?
also, since vb express is free, using notepad/ed/vbc/msbuild/debug.exe seems a bit unproductive?
53

<darril@xxxxxxx> wrote in message news:1192481938.179240.318700@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
There's a walk through on this site that takes you through the entire
process from beginning to end:
http://mcitpsuccess.com/blogclrsp.aspx

It shows how to create an external dll without using Visual Studio,
create the assembly in SQL Server 2005, and create a CLR stored
procedure using the assembly.

HTH,

Darril Gibson
MCT, MCDBA, MCITP, MCSE, MCSD
Author, MCITP SQL Server 2005 Database Administration All-in-One Exam
Guide (Exams 70-431, 70-443, & 70-444)

On Oct 3, 5:42 am, Ashwin <Ash...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi again,
I have tried creating assembly but i am just confused of this. Well
according to u I have configured the database engine to run CLR trigger sp.
When i create a new project from BID i dont see project type SQL Server??? I
have used RECONFUGURE.

You said we need to create assembly i tried it from SQL Server Management
Studio using CREATE ASSEMBLY statement but I am confused what to specify in
FROM........ i mean which dll file should i specify? Actually i am not
getting the logic behind creating assembly. Please suggest.

bye.

Ashwin



"Thor" wrote:
> Greetings!

> You have (or attempted to) configured the engine of an instance of SQL
> Server to run CLR sp, fn, trigger, aggregate.
> This is all fine. If you have remembered to run RECONFIGURE after
> sp_configure.

> You also need to add the assembly to your database. This is done with > CREATE
> ASSEMBLY (directly or through Visual Studio).

> To write the code you need Visual Studio Professional (C#/VB).

> Hope this helps
> 53

> "Ashwin" <Ash...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>news:ED31B5DC-C505-4333-834C-CBB1BDE1628F@xxxxxxxxxxxxxxxx
> > Hi All,
> > Can any body please help me how to integrate CLR in SQL Server 2005. > > I
> > have
> > already configured SQL Server Surface Area Configuration. Also > > executed
> > the
> > procedure 'CLR ENABLE', 1 but still I am not able to see SQL Server
> > Project
> > while opening BID new project where we can create SP, Triggers,
> > Aggregates.
> > Please help- Hide quoted text -

- Show quoted text -



.

Relevant Pages

  • Re: SQL Server 2005 - CLR Integration problem
    ... CREATE ASSEMBLY does not create the assembly, it adds an existing assembly from a dll (or you can specify the actual bits!). ... You said we need to create assembly i tried it from SQL Server Management ... Server to run CLR sp, fn, trigger, aggregate. ... > already configured SQL Server Surface Area Configuration. ...
    (microsoft.public.cert.mcdba)
  • Re: SQL Server 2005 - CLR Integration problem
    ... You have configured the engine of an instance of SQL Server to run CLR sp, fn, trigger, aggregate. ... already configured SQL Server Surface Area Configuration. ...
    (microsoft.public.cert.mcdba)
  • 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: 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: Extended Stored Procedures developed in .NET?
    ... >> No, not in managed code. ... There's a KB describing that it is not supported for SQL Server to host ... >> It is not supported for extended stored procedures or sp_OA procedures to call .NET code in CLR; ... >> declare @msg varchar ...
    (microsoft.public.sqlserver.programming)