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 |
|
ofsouto
Starting Member
22 Posts |
 Posted - 2005-09-09 : 15:17:09
|
| Hi, dearIs it possible to create a trigger that generate a text file when inserting, deleting, updating?Thank you very muchObede |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-09 : 16:37:14
|
and put what in the text file?it would be better to audit your data into another table and then periodicaly export that table into a text file.Go with the flow & have fun! Else fight the flow  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-10 : 00:44:52
|
| Did you mean notepad or Excel?Instead of using trigger, export data to file whenever neededLook for bcp in Books On LineMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Generating a text file