SQL Server Developer >> sp_OACreate and DDLHost.exe
Hi,
I have a .NET DLL which I need to access in SQL Server.
I followed David Browne's article on how to register the .NET DLL, use
it like a COM object and access it in SQL Server using the extended
stored procedures.
Here's David Browne's article:
http://www.hide-link.com/ ;lr=&selm=u%24dR%233nTEHA.347...
However, I noticed that the CPU usage of theincreases up to 100% and
this is caused by the dllhost.exe and sometimes there are several
instances of the dllhost.exe. Im not sure why this happens..
I hope some one can help. Im kinda stumped with this problem.
> Hi,
>
> I have a .NET DLL which I need to access in SQL Server.
> I followed David Browne's article on how to register the .NET DLL, use
> it like a COM object and access it in SQL Server using the extended
> stored procedures.
>
> Here's David Browne's article:
> http://groups.google.com.ph/groups?hl=tl&lr=&selm=u%24dR%233nTEHA.347...
>
> However, I noticed that the CPU usage of theincreases up to 100% and
> this is caused by the dllhost.exe and sometimes there are several
> instances of the dllhost.exe. Im not sure why this happens..
>
> I hope some one can help. Im kinda stumped with this problem.
>
> Thanks in advance for the help!
>
> Mayet
>