Re: SQL Server 2005 - CLR Integration problem

Hi!

CREATE ASSEMBLY does not create the assembly, it adds an existing assembly from a dll (or you can specify the actual bits!).
To write the code you want to use Visual Studio Professional (C#/VB).

Hope this helped
G

"Ashwin" <Ashwin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9188F026-11A2-40D8-B454-A2C4CD683450@xxxxxxxxxxxxxxxx
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" <Ashwin@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

.

Relevant Pages

  • 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)
  • 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: Failed to register SharePoint Services 2007
    ... with SQL Server 2K and use that instead of SQL Server 2005. ... When I ran the configuration databse for the first time I had a failure ... System.ArgumentException: Exception of type ... So I used the ntrights to get that privilege on my sharepoint user. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Failed to register SharePoint Services 2007
    ... with SQL Server 2K and use that instead of SQL Server 2005. ... When I ran the configuration databse for the first time I had a failure ... System.ArgumentException: Exception of type ... So I used the ntrights to get that privilege on my sharepoint user. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Server Configuration
    ... Determining the best configuration for your SQL Server has a few ground ... as the backplane is configured as RAID1 you'll have great redundancy ... Monitoring CPU Usage ... For more information about performance tuning and configuration, ...
    (microsoft.public.sqlserver.setup)