Here is the problem.I run store proc from SQL task in DTS
package.In store proc I use "INSERT INTO"
operator,something like this:

INSERT INTO t1
SELECT f1,f2,f3,f4
FROM #temp
WHERE NOT EXISTS
(SELECT f1,f2
FROM t1
WHERE f1=#temp.f1 and f2=#temp.f2
)
Insert operator hangs up and never finish.
When I run sp_who in query analyzer at the same time,
I see DBCC process with blk=8.

But the interesting point is when I run the same procedure
from query analyzer (not from DTS),it runs fine.Any idea
what it might be?
I use SQL Server 7.

Thanks.

I presume the blocked process is the INSERT statement ?
Do you have anything else going on in the package at the same time?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Paul Kalinin" <pkalinin (AT) partners (DOT) org> wrote

Yes,the statement I told about.
sp_who output looks like this:

Blk DBName Command ProgramName
.....
8 --- DBCC
0 --- INSERT DTS Desiner
.....

Nothing else is running in the package at that time.
Thanks,Paul.





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!