sram24_mca (6/20/2008)
SELECT@ServiceID = I.ServiceID, @Name = I.[Name],@LocationID = I.LocationID, @ModifiedBy = I.CreatedBy,
@Deleted = I.Deleted
FROM INSERTED I
One problem with your trigger straight off, ignoring performance problems...
It only caters for single row updates.
The inserted table contains all the rows affected by the update. If the update affects more than 1 row, then your select there will return the values for 1 row. No guarentees which one.
On the performance side, what problems are you seeing?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability