Vista - Procedure block

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.

Hi Helbert,
To clarify -- what technology are you using for your window-based
application?

Ivo

"helbert" wrote:

> 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.