2008-04-25

SQL Server vs CREATE TRIGGER

Using SQL Server 2000, a CREATE TRIGGER statement must be the first statement in a batch.  However, unlike other statements with that requirement, you cannot even put a SET XACT_ABORT ON statement in front of it.