Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trigger preventing table deletes 1
- Thread starter Luzian
- Start date
-
1
- #2
mrdenny
Programmer
- May 27, 2002
- 11,595
Put a column in your table that is called ReadOnly or something to that effect. Make is a bit data type. If it's not deleteable set ReadOnly to 1.
Have a trigger on the table setup that checks the max value of the ReadOnly field in the deleted column. If the value is 1 issue a rollback command.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Have a trigger on the table setup that checks the max value of the ReadOnly field in the deleted column. If the value is 1 issue a rollback command.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question