>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.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________