may be sys too busy,some source had locked not release. pls USE SP_LOCK ro check which object has locked in SQL SERVER.
我用sp_lock 查了一下得出以下結果﹕ (我的數據庫id 為 9 ) 53 9 817437986 0 PAG 1:2233 IS GRANT 53 9 817437986 0 TAB IS GRANT 53 9 0 0 DB S GRANT 53 9 804913939 0 RID 1:67137:7 S GRANT 53 9 817437986 0 RID 1:2233:1 S GRANT 53 9 762485795 0 TAB IS GRANT 53 9 804913939 0 PAG 1:67137 IS GRANT 53 9 804913939 2 PAG 1:7532 IS GRANT 53 9 804913939 0 TAB IS GRANT 53 9 817437986 0 RID 1:2233:3 S GRANT 53 9 804913939 2 PAG 1:42636 IS GRANT
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 57
Process ID: 836Connection Broken另 ﹕第 14 和 第 15 行為向一臨時表里插入數據。
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 64
Process ID: 836Connection Broken
但在數據量不是很大時﹐卻可以正常執行。 ( 注﹕ 以前不論數據量大小都可以。)
請各位高手相助。
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 64
Process ID: 836Connection Broken
但在數據量不是很大時﹐卻可以正常執行。 ( 注﹕ 以前不論數據量大小都可以。)
請各位高手相助。
pls USE SP_LOCK ro check which object has locked in SQL SERVER.
(我的數據庫id 為 9 )
53 9 817437986 0 PAG 1:2233 IS GRANT
53 9 817437986 0 TAB IS GRANT
53 9 0 0 DB S GRANT
53 9 804913939 0 RID 1:67137:7 S GRANT
53 9 817437986 0 RID 1:2233:1 S GRANT
53 9 762485795 0 TAB IS GRANT
53 9 804913939 0 PAG 1:67137 IS GRANT
53 9 804913939 2 PAG 1:7532 IS GRANT
53 9 804913939 0 TAB IS GRANT
53 9 817437986 0 RID 1:2233:3 S GRANT
53 9 804913939 2 PAG 1:42636 IS GRANT