I had to put this task down for awhile, but now I'm back at it.  I'm trying to execute the script in Query Analyzer while being connected to the destination...

Karen,

Thanks for the kind response.  I think I must not have phrased my original question properly.  The database I'm developing is definitely an RDBMS system.  What...

I never asked for an assessment of my skill level.  I'll readily admit that I am by no means a certified DBA, but I am certainly past having to read...

Well, I figured that it was something simple that I missed and it was.  It was a clustered index issue and I simply made the primary key columns non clustered since the tables...

Certainly.  Here it is.

CREATE PROCEDURE dbo.spStatusReviewInsert

(--Pramater List 35 or so fields)

AS

DECLARE @errorcode int

BEGIN TRAN

INSERT INTO StatusReview(--Fields)

VALUES(--Values)

--Execution stops here after completion of trigger.  @@ERROR may be zero anyway, but...