All we have 2 process invoking the same stored procedure at the same time and both of them are hung . They start yielding other resources but they never progress or complete .
Is this something to do with deadlock or resourcing locking , has anybody come across it or throw an insight of how the whole thing works ? Any solutions or suggestions ?
The sp uses cursors !!