Copy Code Trigger Definition 

        
                    CREATE trigger TR_CONSTITUENCYCRITERIASPOUSE_ONLYONEROW 
                        on dbo.CONSTITUENCYCRITERIASPOUSE 
                        after insert 
                        not for replication
                    as begin
                        if ((select count(ID) from dbo.CONSTITUENCYCRITERIASPOUSE) > 1)
                            RAISERROR('ONLYONESTUDENTSETTINGSROW', 16, 1);
                    end