|
Posted by David Portas on 10/18/51 11:26
In SQL Server 2000 you can reference COM objects using the sp_OA procs.
Take a look at sp_OACreate in Books Online for an example. This method
may have some potential for memory leaks if external code is called
frequently, at least in my experience, so load test it carefully.
If you are working in C++ you may also create an extended stored proc.
See "Creating Extended Stored Procedures" in Books Online.
In SQL Server 2005 you can catalogue .NET assemblies as stored procs
and call them directly.
Do consider that your requirement might be better implemented as a
middle-tier component. Operate on your database from your application
code rather than call back to the application from within the database.
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|