so we have 3 tables involved here, what is the source and destination tables of the data being transfered? Are the tables in the same database?

-- Same database

Are you transferring the data in one big gulp or is it broken out into smaller batches of say 1000 to 5000 records?

-- One big gulp

** Correction ** ALTER TRIGGER [dbo].[patient_property_arrival] ON [dbo].[pp]...

CREATE NONCLUSTERED INDEX [NonClusteredIndex_pp] ON [dbo].[pp]

(

[p_id] ASC,

[s_name] ASC,

[pro_id] ASC,

[checked] ASC,

[timestamp_ts] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO