Sean Lange (7/18/2013)

---

Or even simpler would be to change the loop condition.

WHILE EXISTS(SELECT * FROM #TempTable)

You posted in the sql 7, 2000 forum. Are you actually using an old version...

What is the point of the RETURN call in the trigger, if it doesn't cause the trigger to end execution?

But shouldn't the trigger exit prior to getting to the part where the user doesn't have permissions? Or does it automatically check for permissions regardless of whether the code is...