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 |
|
pnpsql
Posting Yak Master
246 Posts |
 Posted - 2012-01-20 : 23:24:49
|
| Hi team, i need to update tables regularly, please let me know if there is anyway that warns me before i update.challenge everything |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-01-21 : 05:56:04
|
| 1) Place a warning on the application side. If your application is about to send an UPDATE statement - create a warning for the user2) Create an audit table - so even if the update is incorrect - you can troubleshoot through the audit tableJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-22 : 17:48:21
|
| also you can consider to use trigger for this.Sr Sql server DBA/Artitech |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-01-23 : 01:39:27
|
| Yes, triggers and audit tables can work well togetherJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
update warning in sql server