From the information Provided is difficult to infer the reason but this is something you need to think about:

1. You are creating two records per updated records on that table

2....

Simple, a person like you "experienced", is already leaving #10 for Henderson and Tripp and if you get to know more people better than them are you going to send...

Adam, just answer me two questions: 

How long have you been working with SQL Server? 

Do you consider yourself experienced with it?

If you *really* need such functionality I would execute the code in a "separeated connection" like an SQL Agent Job, DTS, ROWSET functions or sp_OA* procedure calls

Honeslty I have had very painful experiences being on the interviewee side of the table!

Questions like

"how good your SQL Server skills are, on a scale of 1 to 10" ?

are...

Sorry for the bad news but SQL Server CE does NOT supports stored procedures

Not sure about the access violation but I can tell you there are a lot of things wrong with that code (no offence) :

1.It is...

However you cannot tell it to stop firing on delete but continue firing on inserts and updates

If you need that functionality just keep each trigger code separated

(one for insert, one ...

I don't think this type of operation is meant to be performed a lot of times of very often that's why I thought about select into

if resources allow it use SELECT INTO   instead of insert for speed

The real problem maybe is that we are guessing !!

I can also interpret that: each of the "column_name" is a different column

a possible solution to pattern search may be this one:

select a.id

from

      Answers a cross join searchconditions s

group by a.id

having sum( case when a.text like s.search +'%' tehn 1 else...

NeuralC

You are correct the exists was my oversite I stand corrected and I am glad you got the right solution from Jesper

Who said is finished?

select @ACCOUNTTIME = case when @ACCOUNTTIME is null then 0 else @ACCOUNTTIME  end

The condition should probably be:

WHERE left(column, 2) ALL (select SearchItem from SearchTable)

but then again is not a pattern match is an exact match