TR_APPLICATIONURLPARTS_LIMIT (Trigger)

                
                    CREATE trigger TR_APPLICATIONURLPARTS_LIMIT on dbo.APPLICATIONURLPARTS after insert
                    as begin
                        if (select count(ID) from dbo.APPLICATIONURLPARTS) > 1
                        begin
                            exec dbo.USP_RAISE_ERROR
                            rollback tran
                        end
                    end