Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdgoyal
Starting Member
1 Post |
 Posted - 2005-02-15 : 13:44:24
|
| Does anyone have a preferred method to prevent a row from being deleted from a table even by a person with all admin rights. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-15 : 13:49:21
|
| Preferred method: remove permissions from the admin.2nd method: ROLLBACK TRAN inside the triggerTara |
 |
|
|
|
|
|
Prevent row from deletion