COM object from Store Procedure

Hello there
Can i use a COM object from Store Procedure?
Thanks-
--
<Harvey Triana />Harvey Triana wrote:

> Hello there
> Can i use a COM object from Store Procedure?
> Thanks-
> --
> <Harvey Triana />
In SQL Server 2000 take a look at the sp_OA procs in Books Online:
sp_OACreate, sp_OAMethod, etc.
In SQL Server 2005 the preferred alternative would be to call a .NET
class from a proc.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Dont forget to use sp_OADestroy to destroy the object when you are
done. We have seen memory leak issues when we didnt use sp_OADestroy.
SAI|||Thank a lot-
yes, i know kindnesses of 2005 version.
But, i want testing SQL Server 200/COM vs SQL Server 2005/VB.NET in this
plan (I s the best efficiency)
<Harvey Triana />
Drilling View Developer (52 oil wells in 2005)
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> escribi en el
mensaje news:1138724769.911891.36830@.o13g2000cwo.googlegroups.com...
> Harvey Triana wrote:
>
> In SQL Server 2000 take a look at the sp_OA procs in Books Online:
> sp_OACreate, sp_OAMethod, etc.
> In SQL Server 2005 the preferred alternative would be to call a .NET
> class from a proc.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>