Andy/jpipes

Thanks for your help guys but have FINALLY figured this one out - the problem lay in the select scope identity.

Nasty, nasty bug that lay in our code for years...

This is the stored procedure that inserts the new entry into tableA

CREATE PROCEDURE [dbo].[mmap_sp_Insert_OutgoingMessages]

@inp_SendDateTime AS DATETIME = NULL,

@inp_Sender AS NVARCHAR(30) = NULL,

@inp_MessageText AS NTEXT = NULL,

@inp_Status AS INTEGER = NULL,

@inp_DateTimeSent...

Hi, the table is as in the first message 🙂

primary key is identity field MessageId, no other index. only getting 4-6 successful inserts to the table per minute, thought...

Only TableB has added indexes.

Primary key of TableA is the identity field MessageID, primark key of tableB is the identity field ID.

What would you suggest Andy/anybody?