Paul,
SQL Server allows to work with COM server using set of system stored procedures: sp_OACreate, sp_OAGetProperty, sp_OASetProperty, sp_OAMethod, sp_OAGetErrorInfo and sp_OADestroy. I'm not sure what you're trying to do but keep in mind that it isn't the best way to work with data. It could be much slower than using stored procedures.
>Newbie here to SQL Server. Is it possible to create object references to COM objects in SQL Server the way one does in VFP? I have many objects written in VFP and would like not to have to recode them as stored procedures in SQL Server.
>
--sb--