|
 |  |  |  |  |  |  |
Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
 |
| |||||||
| | Thread Tools | Display Modes |
03-06-2006
| #1 (permalink) |
| Guest | 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. |
|
03-18-2006
| #2 (permalink) |
| Guest | RE: Procedure block 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. |
| |
| |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Procedure Details | AdityaKir | PowerShell | 1 | 2 Weeks Ago 03:29 AM |
| executing sql stored procedure | november_hotel | VB Script | 1 | 3 Weeks Ago 11:30 AM |
| Restore Procedure... | Bob | Vista installation & setup | 4 | 08-29-2007 03:14 PM |
| Activation procedure | Craig Musgrove | Vista installation & setup | 2 | 04-18-2007 11:57 PM |
| Uninstall procedure | NoNoBadDog! | Vista installation & setup | 0 | 08-29-2006 08:48 PM |
Linear Mode
