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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Use Triggers to prevent changes
- Thread starter edsargent
- Start date
sodakotahusker
Programmer
- Mar 15, 2001
- 601
There are two temporary tables created when a trigger files. One contains the old values and the other contains the new values. You can compare the values in the table containing the old values and if there is something disagreeable about that data - roll it back.
Perhaps this link will help - though this appears to be sybase but it looks identical to SQL Server to me.
Perhaps this link will help - though this appears to be sybase but it looks identical to SQL Server to me.
mrdenny
Programmer
- May 27, 2002
- 11,595
Basically what it comes down to is if you put a rollback command in the trigger the calling command is also rolled back.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question