SQL Server Performance Forum – Threads Archive

Export and Print

Hi Everybody, I need to take the value from the table(sqlserver2005)and then export as a file and then print the file in the printer. This process should be work in automatic, like the automatic response of email. Can anyone help for me… with love
Venkatesh M

---

you could set up a scheduled task in windows to bcp out the relevant data, and then print the resulting text file. if you want the column headers to show up with the data when you call bcp, see this link: http://www.sql-server-performance.com/bcp.asp or this one: http://weblogs.sqlteam.com/brettk/archive/2005/04/13/4395.aspx www.elsasoft.org

---

I’m not sure whether using Reporting Services is more managable for printing purose, not sure and welcome any feedback. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

---

]]>