Copy Code Trigger Definition 

                
                    CREATE trigger TR_VSECATEGORY_DELETE on dbo.VSECATEGORY
                    for delete
                    not for replication
                    as begin
                        set nocount on;

                        if dbo.UFN_VSECATEGORY_ALLROWSEXIST() <> 1 begin
                            rollback tran
                            raiserror('A row is required to be in the table for each VSE category.',16,10)
                        end
                    end