all groups > sql server notification services > june 2007 >
You're in the

sql server notification services

group:

SQL-NS 2005 StockBroker Sample doesn't notify


SQL-NS 2005 StockBroker Sample doesn't notify James
6/12/2007 11:31:51 AM
sql server notification services:
From Ch.3 of Shyam Pather's SQL-NS book, I have followed the instructions
exactly as stated in the book, I get success on the TEST and setup_all and I
get no errors when aI start the service as described on pg. 69-70. I run
the Test.sql file that inserts records in the StockBroker database, and it
runs without any errors. However, the file 'FileNotifications.txt' is NOT
written to no matter hopw long I wait. What gives?



Thanks,



James Klett

jimklett @ mathias-die . com


Re: SQL-NS 2005 StockBroker Sample doesn't notify James
6/12/2007 3:24:36 PM
This is what I see in the NotificationBatchesStatusCodes table

0 Undone
1 Generating
2 Generated
3 Creating distributor work items
4 Created distributor work items
5 Failed to generate
NULL NULL


JIM


[quoted text, click to view]

Re: SQL-NS 2005 StockBroker Sample doesn't notify gkorobkov
6/23/2007 3:49:48 PM
[quoted text, click to view]

Excuse me. Where I can get or download source code for this book?
(Microsoft=AE SQL Server 2000 Notification Services by Pather Shyam)
Please, if it possibe could you send it on my e-mail
gkorobkov@gmail.com

Best regards
George Korobkov.
Re: SQL-NS 2005 StockBroker Sample doesn't notify James
6/25/2007 1:12:07 PM
Buy the book from Amazon, the CD is in the back. It would be illegal for me
to send you the code without Shya getting his royalty

:-)



JIM


[quoted text, click to view]

Excuse me. Where I can get or download source code for this book?
(Microsoft® SQL Server 2000 Notification Services by Pather Shyam)
Please, if it possibe could you send it on my e-mail
gkorobkov@gmail.com

Best regards
George Korobkov.

AddThis Social Bookmark Button