Re: SQL Server 2005 - CLR Integration problem

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: CLR-Trigger und temp tables
    ... Meine Frage basiert auf dem Community-Webcast zum SQL Server 2005, ... Trigger nicht installieren kann. ... Ein kleines CLR Trigger Beispiel, dass ich mal in Beta Zeiten verwendet ...
    (microsoft.public.de.sqlserver)
  • 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: 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)
Loading