Saving to a file

[mike718]

I have a trigger that is run everyday that updates a table. I would like to automatically save the contents of that table to a file. Is there anyway to write that into a script? Also when I save a file manually to a csv file I always get commas to seperate columns, is there any way that i can have that option turned off when saving??

Thanks

Mike

 

[JohnDTampaBay]

Check out BCP in Books Online. It is a command-line utility that will allow you to easily export the contents of a table to a text file. You also have some control over the format of the text file. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[mike718]

Thanks