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 - 2001-06-17 : 19:29:20
|
Deborah Runkle writes "OS Version: Win 2000 sp1
SQL version: SQL 2000 sp1
Informatica: 4.1
Each time the load is started (essentially a BCP) for Informatica it spans multiple threads using the same spid number. The query is the same on all the spids. The query begins to work then it just stops and hangs. The locks are shared and there are no deadlocks happening. Does anyone have any ideas. I'm hoping its just something new that I've never seen.
thanks
Deborah Runkle" |
|
|
|
|
|
Multiple threads same spid ID