>how to prevent deletion of records on sqlserver table except the administrator

In SQL you can explicitly grant or deny permissions on any object (including table) per user or role.