Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BCP and TEMPDB
Message
From
10/08/2000 08:56:54
 
 
To
09/08/2000 17:47:23
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Miscellaneous
Thread ID:
00403099
Message ID:
00403329
Views:
11
A local temporary (#table) is scoped to the connection. I doubt that you'd be able to BCP from it since BCP creates its own connection to the server. OTOH, there should be no issue using BCP to retrieve data from a global temporary table (##table) as long as the connection that created the table still exists. All temporary tables are dropped when the connection that created them is released.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform