I am fairly new to SLQ Server and have a question regarding Triggers.
I have created a trigger table who's sole purpose is to accept records via an MS Access Append query and then perform other stored procedures on the SQL Database.
Because multiple users try to append to this table at the same time and some users run multiple appends simultaneously, the trigger table performance struggles and I get the error "error 3155 (ODBC -- insert on a linked table 'CHECKTRIGGERTABLE' failed.)
The thing is I really dont care if the record appends to the table. All I care about is being able to run the stores procedures with the data that is trying to be appended.
This whole logic is a band-aid solution until I can completely eliminate some 3rd party logic that needs MS Access so I can run the stored procedure directly. But for the time being this is in production and am getting integrity issues due to the crash that I beleive is record locking.
If I remove locks from the trigger table will this allow me to execute the triggered stored procedures without any data integrity issues?
If so, How do I do this?