<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=416243219-25032003><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial size=2>My thoughts so far
are:</FONT></SPAN></DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial size=2>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?</FONT></SPAN></DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=416243219-25032003><FONT face=Arial size=2>Does anybody have
any thoughts or suggestions?</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial color=#0000ff size=2>Mike and Doris
Manning</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:mikedorism@ntelos.net">mikedorism@ntelos.net</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:manning7@shentel.net">manning7@shentel.net</A></FONT></DIV>
<DIV> </DIV></BODY></HTML>