trigger to select into a text file

Last Post 16 Jun 2006 06:05 AM by dbandee. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

29 May 2006 05:27 AM
I want to write a trigger on an insert that does a select from a table andputs the results into a text file (preferably a delimited file).
How do I do this?
New Member
New Member

16 Jun 2006 06:05 AM
i would create a .bat file with OSQL command to create text file from select and call thath .bat fiile from trigger xp_cmdshell '\\MYPC\c$\CreateTextFile.bat'

hope it helps

Acceptable Use Policy