We know about triggers as they exist in SQL Server 2000 and its previous versions ? triggers that fire in response to INSERT, UPDATE and DELETE events. They are now called as DML triggers ...

Running the code between BEGIN and END works fine, but when I create the trigger, I get the following error:<BR><BR><I>"Maximum stored procedure, function, trigger, or view nesting level exceeded ...