microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Inconsistent Double-Ups out of the Generator

Subject: Re: Inconsistent Double-Ups out of the Generator
From: Joe Webb
Date: Wed, 05 Oct 2005 05:33:38 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Ahh....good! Thanks for posting the follow up!

-- 
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)


On Wed, 5 Oct 2005 04:39:10 -0500, "Jason Liddiard"<[email protected]>
wrote:

>Hi Kate, Joe, Colin
>
>Thank you all so much for your help on my double up problem. I have read all 
>your suggestions (GETUTCDATE) and "Last Processed Time" and have decided the 
>problem was something a little more obvious. Double entries in the 
>SaleAddedLog table causing duplications. Upon clearing the table and 
>re-testing, no duplications were produced. An error that never should of 
>happened. I guess I was tired and could not see the wood through the trees.
>
>Thanks again for taking the time to respond. I am now creating another SSNS 
>application and shall take the input gained from your post with me.
>
>Thanks again
>
>Regards
>Jason Liddiard

<Prev in Thread] Current Thread [Next in Thread>