Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  sp_bindsession and Extended Procs

Author  Topic  sonic Starting Member 11 Posts Posted - 2001-03-19 : 16:52:21 Hey all! Thanx for reading this... I have a VB component that exports results of a proc to an XML file (using ADO and DOM). It works fine, except in triggers, which is where I need it. Triggers can only support one connection at a time (implicit transaction, y'know) and the second connection that the COM component needs is always timing out. I recently read something about sp_getbindToken and sp_bindsession in which you can bind connections to run under one transaction. But this can only be used in extended stored procedures, which only support C/C++ components, not VB (arg!). Has anyone written an extended proc before and has some sample code handy? That would be great! Something using the sp_getToken/bindsession would be wonderful. Thanks again!! J'son