external function

Does anyone know how to call a external function which is writter using VB
or C from Transact-SQL? or is it possible to call a external function? We
are using SQLServer 2000?
Thanks,
LijunYou could create extended stored procedures in languages like C, C++. See
SQL Server Books Online for more information, and SQL Server CD has some
samples as well.
You could also use sp_OA* system stored procedures, to instantiate COM
objects from within your stored procedures and other SQL scripts. Type in
sp_OA in the SQL Server Books Online to see a list of stored procedures and
examples.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Lijun Zhang" <nospam@.nospam.nospam> wrote in message
news:%23fRgUlr2DHA.2060@.TK2MSFTNGP10.phx.gbl...
Does anyone know how to call a external function which is writter using VB
or C from Transact-SQL? or is it possible to call a external function? We
are using SQLServer 2000?
Thanks,
Lijun|||Hi Lijun,
Thank you for using MSDN Newsgroup!
I would like to follow up on this issue and see if you stilll have
questions about this issue. Should you have any questions, please feel free
to post here. Looking forward to your reply!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql