all groups > sql server notification services > february 2006 >
You're in the

sql server notification services

group:

looking for book suggestion


looking for book suggestion Jake
2/28/2006 10:26:52 AM
sql server notification services: Hello,

I am looking for a book on notification services. Specifically samples
that deal with faxing out documents from notification services. Thanks in
advance.


Re: looking for book suggestion unc27932 NO[at]SPAM yahoo.com
2/28/2006 4:32:20 PM
I checked out Joe Webb's book (he's often on the board too, and answers
lots of questions) - the book is:

Rational Guide to SQL Server Notification Services

http://www.amazon.com/gp/product/0972688811/qid=1141172975/sr=8-1/ref=sr_8_xs_ap_i1_xgl14/103-5836363-6955067?n=507846&s=books&v=glance

There's also Shyam Pather's book.
http://www.amazon.com/gp/product/0672327791/qid=1141173040/sr=1-1/ref=sr_1_1/103-5836363-6955067?s=books&v=glance&n=283155

Joe's is very easy to follow, and though written for SQL 2000, all the
main concepts are there and have helped me greatly in designing our
2005 instance. Can't speak for Shyam's book, although I'm sure it's
great.
Re: looking for book suggestion Jake
2/28/2006 4:54:23 PM
Thanks for the suggestions. Am I correct that you can send faxes out via
notification services?


[quoted text, click to view]

Re: looking for book suggestion unc27932 NO[at]SPAM yahoo.com
2/28/2006 7:18:19 PM
I have read that you can, but you must build a custom delivery
channel/delivery protocol. The experts (not me) hopefully can answer
more to this question.

[quoted text, click to view]
Re: looking for book suggestion Joe Webb
3/1/2006 12:00:00 AM
Thanks for the kind words about the book! I really glad you've found
it useful!

BTW - I am updating it for 2005, but I don't have an exact release
date yet.

Cheers!

--
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

[quoted text, click to view]
Re: looking for book suggestion Joe Webb
3/1/2006 12:00:00 AM
I think you've got a couple of options:

There may be a 3rd party vender out there that wraps up fax
notification delivery functionality for you, but Microsoft has changed
their web site and finding a SQLNS partner is not nearly as easy as it
once was.

If you'd like, you can develop your own delivery protocol by either
developing everything from scratch (yuck) or incorporating and
existing product into your delivery protocol by invoking its API. The
former involves low level control of the modem port, etc. The latter
makes use of a 3rd party product that already does that kind of stuff
for you. For example, if you can programmatically control FaxMaker or
some other fax program, you can call it from your custom delivery
protocol. Just be cognizant of the time it takes to fax someone.

HTH....

Joe




--
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


[quoted text, click to view]
Re: looking for book suggestion Jake
3/1/2006 8:46:22 AM
Joe,

Thanks for the suggestions. Have you done something like this? Do you
have a recommendation on a 3rd party control?


[quoted text, click to view]

Re: looking for book suggestion Joe Webb
3/2/2006 12:00:00 AM
Hi Jake -

No, I've never configured a SQLNS system to use faxes for delivery.
I've consulted in a shop where they used FaxMaker to send bulk faxes
to various recipients. They seems to like it, but I didn't really have
any insight into that area.

I cannot imagine that calling a faxing API from a custom delivery
protocol would be very difficult.

Maybe someone else can offer more specific insight here.

HTH...

Joe



--
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


[quoted text, click to view]
Re: looking for book suggestion unc27932 NO[at]SPAM yahoo.com
3/2/2006 7:57:40 AM
Below is a link to the FaxMaker product that Joe mentions &
documentation on its available API.

http://support.gfi.com/manuals/en/ffn11/ffn11manual-1-82.html

They mention however that they recommend just using the normal windows
print queue feature they call their NetPrintQueue2FAX feature. This
sends a normal word document to a windows printer queue, which sends
the fax. You could design your NS applicaiton somehow to send the
notification data to a properly formatted word document, and issue the
print command, pointing to the NetPrintQueue. Not sure how, exactly,
but sounds doable.

http://support.gfi.com/manuals/en/fax12/fax12manual-1-068.html

[quoted text, click to view]
Re: looking for book suggestion Jake
3/2/2006 8:18:17 PM
Guys,

Thanks for all of the responses.

Jake

[quoted text, click to view]

Re: looking for book suggestion kate
3/5/2006 2:33:51 PM
hi Jake

we have implemented NS using fax output here in the UK and it works
very well. We have a custom delivery protocol that includes fax using
the built-in fax api in windows server. If you are interested in
obtaining a copy of the module then please contact me at
info@alert-technologies.co.uk

Kate
AddThis Social Bookmark Button