| Subject: Procedure block |
| Group: microsoft.public.windows.developer.winfx.aero |
| Date: 3/6/2006 9:46:32 AM |
| From: =?Utf-8?B?aGVsYmVydA==?= [Email Address Protection] |
On calling a procedure from a window based application the procedure blocks itself. The SPID of the procedure which is blocking does not reflect in the output of sp_who2 'active'. The dbcc inputbuffer(value in blkby column) gives an output something like 'sys;sp_ 1'. This takes the window based application go on a hang. the spid displays the status of the called procedure as suspended. |
| Back |