There are definitely no triggers involved and I don't think it could be a question of deadlock or silent failure since the code works perfectly in Query Analyzer and I...

The code in the sp is below.

CREATE PROCEDURE MapCandidateData

AS

DECLARE @Cmd varchar (2000)

DECLARE @cris_id int, @office_id int, @title varchar (10), @firstname varchar(255), @lastname varchar(255),

@homephone varchar(255), @workphone varchar(255), @mobile varchar(255),...

That would make sense. Unfortunately, it doesn't apply in this case as I wrote it as a static procedure first. Then when it didn't work, I did a copy/paste, removed...