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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-02 : 08:55:23
|
| Rammohan writes "Hello,My requirement is, I will be inserting data in a table thru some client application, I want to create a text file at some folder in Sql-Server that contains this newly inserted record. To do this what I feel is We need to write an insert trigger, that would do this job. Can any one assist Me in accomplishing this?Thanks In advanceRammohan" |
|
|
Jay99
468 Posts |
Posted - 2002-04-02 : 09:35:49
|
| Create a DTS Package to do the export.Create a job to run the DTS package.Create trigger ON INSERT to check the count and if your size requirement is met, exec sp_start_job.Jay<O> |
 |
|
|
|
|
|
Exporting a tables data automatically when data gets inserted into it