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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-16 : 10:21:55
|
| BL writes "I am trying to create an extended stored procedure which need to query some local temporary tables. Those temporary tables are created before the extended stored procedure is called. However, I got no luck. The extended stored procedure can not see those temporary table at all. "Loopback connection" and "Bound Connections" does not help.I am using DB-Library to get to SQL Server. Is there any anyway, I can get the caller's existing connection - get "DBPROCESS" from SRV_PROC;Thanks for your help" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-05-17 : 04:19:03
|
| ---This is not a technical reply---Sounds very messy to me. Why are they temp tables if they're used across processes,users and sessions????Sounds to me like they should be the genuine article...How hard is it to change them?--I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 05/17/2002 04:19:52 |
 |
|
|
|
|
|
Local Temporary Tables Extended Stored Procedure