I want to write some text into a text file. The text file will be placed in a remote system and the Sql db server is a separate system. I guess there should be some stored proc which would do the above task. but i am not aware of this. This piece of Sql statements should be called from a trigger.(when some DML operations are performed in a table then the trigger would fire and write the contents into the file.) Can anyone guide me how can i do this. will there be any security contraints/problems in writing into a file in one system from the other system. sample code would be much appreciated.
No. My Database will remain in same format. what i need is to append or delete the existing contents in a existing Text file and replace it with some new contents. The text file will remain in a separate system and the database will be in separate system.