TRIGGER OUTPUT

[jrc1]

I am trying to create a trigger(SQL Server 7) that will send output to a printer. The problem I am having is I cannot figure out what command to send the output to the printer. What command should be used to send output to a printer in a trigger?

Jeff
jchie@vafb.com

 

[foxdev]

Jeff, I don't believe this is possible as a native function, at least not in SQLS 7.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[TomSark]

well... if you can do it in DOS, then you can do it by calling xp_cmdshell ( as type filename > LTP1: or whatever) .

You can also create an active-x component, instantiate it sp_oacreate), and call some methods (sp_oamethod) to accomplish your needs as well..

However, as foxdev (TIPMASTER OF THE WEEK) stated, you cannot directly access the printer.

You can also store the results and print them off from another job at a later time... Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[foxdev]

Following up on Tom's idea, you could have a log table where the output is placed, then use the client tool of your choice to print it once a day or whenever. You would also eliminate any possible headaches with the trigger failing because of some external I/O problem.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[TED172]

I think from DOS you can try PRINT (file_name) command to print from command prompt (cmd)
Not quite sure how it works. Just a try is a worthwile.