I get this error when trying to update some rows from SQL Server Management Studio v18.5:
Msg 50000, Level 16, State 1, Procedure UPDATElimit, Line 7 [Batch Start Line 0] To many rows being processed at one. Reduce and try again. Msg 3609, Level 16, State 1, Line 1 The transaction ended in the trigger. The batch has been aborted.
How can I bypass this limitation?
ALTER TRIGGER [dbo].[UPDATElimit] on [dbo].[table] FOR UPDATE AS BEGIN IF (select count(*) from inserted) > 1000 BEGIN RAISERROR('To many rows being processed at one. Reduce and try again.', 16, 1) ROLLBACK END END