How to delete records in sql if rowcount exceeds certain row count simultaneously?

im trying to make a log file using sqlserver 2008 database through vb.net.if the row exceeds 1000,then delete top 100 row.everytime the table exceeds 1000 rows,the process will repeat (loop).is it possible to do it?btw,im new to sql.need help with the script