Copy Code Trigger Definition 

        
                    create trigger dbo.TR_RECOGNITIONDEFAULT_ENSUREONEROW_INSERT
                        on dbo.RECOGNITIONDEFAULT
                        after insert
                    as
                    begin
                        set nocount on;
                        
                        if (select count(*) from dbo.RECOGNITIONDEFAULT) > 1
                        begin
                            exec dbo.USP_RAISE_ERROR;
                            rollback transaction;
                        end
                    end