how to call a funtion within a dll from a stored procedure

hi all,
i want to call a function of an activex dll from a stored procedures, Can some tell me how i can do that . The activex dll i want to call has been built using Visual C++ 6.0 .
Regards,
ManpreetDont have any idea how to do that in SQL 2000, but that is definitely a feature present in SQL server Yukon|||You will have to create an extended stored procedure and add it to ss using sp_addextendedproc.

The following link will help:

link (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q190/9/87.asp&NoWebContent=1)