[dba-SQLServer]Need to create PDF Print Server

Mike and Doris Manning mikedorism at ntelos.net
Tue Mar 25 13:40:05 CST 2003


We would like to create our own version of a PDF Print Server.  Basically,
we want to pass information (report name, parameters, requestor name) to our
SQL Server via a sproc.  We then want SQL Server to generate a PDF file
which will then be stored in a designated place on the network for pick up
by the calling program.
 
Getting the info to SQL and generating the PDF is already handled.  Figuring
out how to tell SQL Server when there is info to be processed is the issue
we are trying to make a decision on.
 
My thoughts so far are:
 
1) Create an Insert Trigger that fires a DTS ActiveX script to open an
Access session (if not already open), process anything in the file and shut
down when there are no requests.  Question here is when control would return
to calling program?
2) Create a DTS schedule to start up a "monitoring" database which would
operate during normal business hours.  Question here is how to handle
after-hour needs.
 
Does anybody have any thoughts or suggestions?
 
Mike and Doris Manning
mikedorism at ntelos.net
manning7 at shentel.net
 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3524 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030325/fbcc2dd2/attachment.bin>


More information about the dba-SQLServer mailing list