SQL Server Performance Forum – Threads Archive

Print the Data as a file from SqlServer2005

Hello EveryBody, I have been stored the values in the format of HTML tags in SQLserver table.Because to maitain the format of the letter. i have to take this values from the sqlserver and i need to print this data in the format of file(.HTML) in the printer. The printer has been scheduled and the files should be printed in that particular time in the printer automatically like scheduling in the DTS so this complete process should work automatically. How to assign the job to printer for the particular time from sql server2005? if anybody want to clarify this questions or having any doubt about this question
plz free to contact this email id [email protected] , its my personal ID. Plz,Can any one help for me. With Love
Venkatesh M

Copy the HTML format to a .HTML file from SQL and execute the batch file for printing…this can be done using DTS and schedule the dts as needed… Print Files from Batch Files
http://www.robvanderwoude.com/printfiles.html
MohammedU.
Moderator
SQL-Server-Performance.com

You can take advantage of XML in this case using the HTML format tags, for printing this is more conveneint way to proceed. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] fun side you have to subscribe the thread to get an intimation about any update on your question. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</center>

]]>