trigger to select into a text file

Last Post 16 Jun 2006 07:05 AM by dbandee. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kamirob
New Member
New Member

--
29 May 2006 06: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?
dbandee
New Member
New Member

--
16 Jun 2006 07: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
You are not authorized to post a reply.

Acceptable Use Policy