by John Fishe » Sat, 28 Mar 1998 04:00:00
I am trying to write extended stored procedures for SQL Server 6.5.
What are the available ways to access data in SQL Server from the
extended stored procedure (ie. DBLib, OLE-DB or ADO)? I would also
appreciate any further help/comments on extended stored procedures.
Thanks,
Brian Fisher
Mullin Consulting
by Sean Kel » Tue, 31 Mar 1998 04:00:00
you just named them :)Quote:>I am trying to write extended stored procedures for SQL Server 6.5.
>What are the available ways to access data in SQL Server from the
>extended stored procedure (ie. DBLib, OLE-DB or ADO)?
While an extended stored procedure is called and runs in the same
memory space as SQL Server, it has to open its own connections to the
server to run queries etc. It can, however, send messages and errors
back to the server. Also, be warned, it DOES run in the same meory
space as SQL Server and any bugs/memory leaks in your code will affect
the server as well. To get started I'd look at the xp's included and
get the SQL Server developer's kit (I think that's what it is called)
-- it is available on the SQL page of microsoft's site.
-Sean
1. Stored Procedures vs Extended Stored Procedures
In MSDN, it says that there is a "Performance advantage" using extended
stored procedures. Has anyone used an extended stored procedure? If so,
what is the real advantages for using them instead of a normal Stored
procedure?
(I know that you can create extended stored procedures in C, but are there
any other advantages?)
Any help would be appreciated.
John Regnier
2. E_OP0487_NOEQCLS consistency check
3. Calling extended stored procedure from stored procedure
5. output parameters stored procedures / extended stored procedures
6. erwin
7. Calling stored proc from extended stored procedure
8. VBA functions in DefaultValue property not working correctly
9. Extended stored procedures and Active X Exe
10. Extended Stored Procedures
11. Creation of extended stored procedures - versioning info
12. Creating and using extended stored procedures - help please
13. Extended Stored procedures - quick question