Trigger problem in SQL

[pvpkumar]

Getting a trigger problem in SQL. As the table grows the trigger stops working. Upon reinstallation of SQL the trigger starts working.

The problem was encountered for the following database/table details

1. Database size 2.25 GB
Table size over 2 million records.

2. Database size 250 MB
Table size 50,000 records.

Thanks

P.Kumar

[Schimelcat]

Did you reach the max number of records for a table? If your trigger is an Insert trigger and the table can no longer add records then the trigger would fail. I know there is a max number, I just can't remember what it is.

[pvpkumar]

Did you reach the max number of records for a table? If your trigger is an Insert trigger and the table can no longer add records then the trigger would fail. I know there is a max number, I just can't remember what it is.

It's not definitely because of the maximum no. of records pumped into the table. The maximum no. is either in billions or in trillions.

The Trigger is working after re-installation of MS-SQL. I have a strong feeling that there is database tuning required, which is unknown to me.

Please advise

Thanks and best regards
P.Kumar

[ramasp]

Please specify whether the trigger is for insert or update or delete
the error statement clearly........ .....