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 |
|
amurark
Yak Posting Veteran
55 Posts |
 Posted - 2012-08-23 : 01:22:16
|
| A script which works whenever a table is modified in the database and gives the output as the name of the field which is modified in the table.Ankita |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-23 : 01:45:16
|
| Optin 1 is DDL triggers, but if you haven't yet implemented DDL triggers - check default traceJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
amurark
Yak Posting Veteran
55 Posts |
Posted - 2012-08-23 : 02:12:10
|
| Thanks to All for support and replies,But running trgigger is dangerous or not on production.I want trigger for update command, if any column is updated in single table.Ankita |
|
|
|
amurark
Yak Posting Veteran
55 Posts |
Posted - 2012-08-28 : 11:36:56
|
| Pls help me in geting the code which gives the column name which is modified in the tableAnkita |
|
|
|
|
|
|
SCript to get the modified columns in the table.