SQL Server 2000 - block records being deleted or PK being changed?

Soldato
Joined
8 Feb 2004
Posts
3,822
Location
London
I'm running SQL Server 2000.

Is there a way of stopping a record being deleted, or the primary key value being altered?

I'm guessing it's either a table / column setting, or I need to use pre-triggers somehow.

TIA
 
Back
Top Bottom