"marking" the processed elements in data-driven subscription

I would like to use e-mail delivery for the following scenario: new orders
arrive in a table and i
would like to send confirmation messages which contain the content of the
order. The RS has an "every
5 minutes" schedule and should send e-mail just about the new orders to the
customers.
How could I differentiate the new elements from the old ones?
- or -
How can I "mark" the orders, when the confirmation report was created that
they were processed?
Thanks in advance,
Kolos"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||'
"Bender" <roman.ilic@.avtenta.si> wrote in message
news:%23%23BJFeHgEHA.3416@.TK2MSFTNGP09.phx.gbl...
> "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> > I would like to use e-mail delivery for the following scenario: new
orders
> > arrive in a table and i
> > would like to send confirmation messages which contain the content of
the
> > order. The RS has an "every
> > 5 minutes" schedule and should send e-mail just about the new orders to
> the
> > customers.
> >
> > How could I differentiate the new elements from the old ones?
> > - or -
> > How can I "mark" the orders, when the confirmation report was created
> that
> > they were processed?
> >
> > Thanks in advance,
> > Kolos
> >
> >
> >
>
>|||Hi Kolos,
We do something similar.
We have an additional field in our subscription Queue which has a Processed
Flag field (just a BIT). We update this field whenever the entry has been
processed via the data driven subscription's query. If you don't want to
add a field to this table, you could create an additional table recording a
log of processed Orders.
HTH
Matt
"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||That's on the right track, but I'd like to also point out that an easy way
to update the "flag" field is to use a stored procedure. Within the sproc
you can return the records affected by the email notice and revisit each row
to update the flag value. =)
Matt
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ucN2OnDrEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi Kolos,
> We do something similar.
> We have an additional field in our subscription Queue which has a
> Processed
> Flag field (just a BIT). We update this field whenever the entry has been
> processed via the data driven subscription's query. If you don't want to
> add a field to this table, you could create an additional table recording
> a
> log of processed Orders.
> HTH
> Matt
> "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
>> I would like to use e-mail delivery for the following scenario: new
>> orders
>> arrive in a table and i
>> would like to send confirmation messages which contain the content of the
>> order. The RS has an "every
>> 5 minutes" schedule and should send e-mail just about the new orders to
> the
>> customers.
>> How could I differentiate the new elements from the old ones?
>> - or -
>> How can I "mark" the orders, when the confirmation report was created
> that
>> they were processed?
>> Thanks in advance,
>> Kolos
>>
>|||lol, actually, I do use a stored procedure. I was being just more general
and wasn't sure of Kolos's particular scenario.
"Matt Temple" <mtemple@.dslextreme.com> wrote in message
news:10q9p1l72kj6iaa@.corp.supernews.com...
> That's on the right track, but I'd like to also point out that an easy way
> to update the "flag" field is to use a stored procedure. Within the sproc
> you can return the records affected by the email notice and revisit each
row
> to update the flag value. =)
> Matt
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ucN2OnDrEHA.868@.TK2MSFTNGP10.phx.gbl...
> > Hi Kolos,
> >
> > We do something similar.
> >
> > We have an additional field in our subscription Queue which has a
> > Processed
> > Flag field (just a BIT). We update this field whenever the entry has
been
> > processed via the data driven subscription's query. If you don't want
to
> > add a field to this table, you could create an additional table
recording
> > a
> > log of processed Orders.
> >
> > HTH
> >
> > Matt
> >
> > "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> > news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> >> I would like to use e-mail delivery for the following scenario: new
> >> orders
> >> arrive in a table and i
> >> would like to send confirmation messages which contain the content of
the
> >> order. The RS has an "every
> >> 5 minutes" schedule and should send e-mail just about the new orders to
> > the
> >> customers.
> >>
> >> How could I differentiate the new elements from the old ones?
> >> - or -
> >> How can I "mark" the orders, when the confirmation report was created
> > that
> >> they were processed?
> >>
> >> Thanks in advance,
> >> Kolos
> >>
> >>
> >>
> >
> >
>

"Keys out of order on page (1:10579653), slots 24 and 25..." error messages

Hi,
I have sql server 2000, sp3, and several production databases on this
server. From time to time, my integrity check jobs fail on some of databases
with the error message shown above (not always the same page/slot). This
errors occur on index pages, and I resolve them by rebuilding affected
indexes. Then everything works fine 1-2 weeks, and then again.
Hardware check didn't show anything wrong, but I'm still suspecting that
something is wrong with the disks (EMC, btw). It might be that some disk
block is corrupted. How can I check if it is always the same disk block
(from (1:10579653), slots 24 and 25)?
Interesting part is that I can use corrupted index by forcing the query
through hint, and it doesn't report any error.
Any help?
Thanks,
Peja
I'd run a DBCC CheckDB immediately.
"peja" <peja@.sympatico.ca> wrote in message
news:eJQ76UXrFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have sql server 2000, sp3, and several production databases on this
> server. From time to time, my integrity check jobs fail on some of
> databases
> with the error message shown above (not always the same page/slot). This
> errors occur on index pages, and I resolve them by rebuilding affected
> indexes. Then everything works fine 1-2 weeks, and then again.
> Hardware check didn't show anything wrong, but I'm still suspecting that
> something is wrong with the disks (EMC, btw). It might be that some disk
> block is corrupted. How can I check if it is always the same disk block
> (from (1:10579653), slots 24 and 25)?
> Interesting part is that I can use corrupted index by forcing the query
> through hint, and it doesn't report any error.
> Any help?
> Thanks,
> Peja
>

"Keys out of order on page (1:10579653), slots 24 and 25..." error messages

Hi,
I have sql server 2000, sp3, and several production databases on this
server. From time to time, my integrity check jobs fail on some of databases
with the error message shown above (not always the same page/slot). This
errors occur on index pages, and I resolve them by rebuilding affected
indexes. Then everything works fine 1-2 weeks, and then again.
Hardware check didn't show anything wrong, but I'm still suspecting that
something is wrong with the disks (EMC, btw). It might be that some disk
block is corrupted. How can I check if it is always the same disk block
(from (1:10579653), slots 24 and 25)?
Interesting part is that I can use corrupted index by forcing the query
through hint, and it doesn't report any error.
Any help?
Thanks,
PejaI'd run a DBCC CheckDB immediately.
"peja" <peja@.sympatico.ca> wrote in message
news:eJQ76UXrFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have sql server 2000, sp3, and several production databases on this
> server. From time to time, my integrity check jobs fail on some of
> databases
> with the error message shown above (not always the same page/slot). This
> errors occur on index pages, and I resolve them by rebuilding affected
> indexes. Then everything works fine 1-2 weeks, and then again.
> hardware check didn't show anything wrong, but I'm still suspecting that
> something is wrong with the disks (EMC, btw). It might be that some disk
> block is corrupted. How can I check if it is always the same disk block
> (from (1:10579653), slots 24 and 25)?
> Interesting part is that I can use corrupted index by forcing the query
> through hint, and it doesn't report any error.
> Any help?
> Thanks,
> Peja
>

"Keys out of order on page (1:10579653), slots 24 and 25..." error messages

Hi,
I have sql server 2000, sp3, and several production databases on this
server. From time to time, my integrity check jobs fail on some of databases
with the error message shown above (not always the same page/slot). This
errors occur on index pages, and I resolve them by rebuilding affected
indexes. Then everything works fine 1-2 weeks, and then again.
Hardware check didn't show anything wrong, but I'm still suspecting that
something is wrong with the disks (EMC, btw). It might be that some disk
block is corrupted. How can I check if it is always the same disk block
(from (1:10579653), slots 24 and 25)?
Interesting part is that I can use corrupted index by forcing the query
through hint, and it doesn't report any error.
Any help?
Thanks,
PejaI'd run a DBCC CheckDB immediately.
"peja" <peja@.sympatico.ca> wrote in message
news:eJQ76UXrFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have sql server 2000, sp3, and several production databases on this
> server. From time to time, my integrity check jobs fail on some of
> databases
> with the error message shown above (not always the same page/slot). This
> errors occur on index pages, and I resolve them by rebuilding affected
> indexes. Then everything works fine 1-2 weeks, and then again.
> Hardware check didn't show anything wrong, but I'm still suspecting that
> something is wrong with the disks (EMC, btw). It might be that some disk
> block is corrupted. How can I check if it is always the same disk block
> (from (1:10579653), slots 24 and 25)?
> Interesting part is that I can use corrupted index by forcing the query
> through hint, and it doesn't report any error.
> Any help?
> Thanks,
> Peja
>

"Invalid Cursor State" - REPOST

MS-SQL 2000, Service Pack 3a and 4
I have customers that are starting to get "Invalid Cursor State" messages
returned from my Clarion MS-SQL. based application.
It appears to happen when i am issuing a "SELECT SUM(TOTAL) FROM..."
statement, but i can be sure of that. I cant pinpoint when the problem
starts. The solution has been to close the screen im on, which closes
connection to the database.
Where can i start to look for this problem?
TIA
Tim MorrisonTim Morrison wrote:
> I have customers that are starting to get "Invalid Cursor State"
> messages returned from my Clarion MS-SQL. based application.
>
Tried reading this article?
http://support.microsoft.com/kb/831997
- Peter
--
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!|||Yup. SP4 is applied to the machine giving me the most problems. It does
however happen to SP3a machines as well.
Tim
"Peter Lykkegaard" <plykkegaard@.nospam.nospam> wrote in message
news:eZOsIYKPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Tim Morrison wrote:
>> I have customers that are starting to get "Invalid Cursor State"
>> messages returned from my Clarion MS-SQL. based application.
> Tried reading this article?
> http://support.microsoft.com/kb/831997
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>

"Failed to obtain TransactionDispenserInterface"

This msg. appears in the startup messages in Errorlog.
Failed to obtain TransactionDispenserInterface: Result
Code = 0x8004d01b
It occurs about the 10th line in Errorlog and follows:
Attempting to initialize Distributed Transaction
Coordinator.
What causes it? How to fix it?
(SQL Server 7.0, SP4, NT 4.0)
Thank you.This error is reported if the MSDTC service is not running
when SQL starts. Makse sure the MSDTC service is
running and set it's startup to automatic if it's required
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"bd" <bruce.drechsler@.delphi.com> wrote in message
news:098c01c34bd0$69906f60$a001280a@.phx.gbl...
This msg. appears in the startup messages in Errorlog.
Failed to obtain TransactionDispenserInterface: Result
Code = 0x8004d01b
It occurs about the 10th line in Errorlog and follows:
Attempting to initialize Distributed Transaction
Coordinator.
What causes it? How to fix it?
(SQL Server 7.0, SP4, NT 4.0)
Thank you.|||MSDTC is not required at this time. I'll consider the
messages informational, only.
Thank you.
Bruce
>--Original Message--
>This error is reported if the MSDTC service is not running
>when SQL starts. Makse sure the MSDTC service is
>running and set it's startup to automatic if it's required
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"bd" <bruce.drechsler@.delphi.com> wrote in message
>news:098c01c34bd0$69906f60$a001280a@.phx.gbl...
>This msg. appears in the startup messages in Errorlog.
>Failed to obtain TransactionDispenserInterface: Result
>Code = 0x8004d01b
>It occurs about the 10th line in Errorlog and follows:
>Attempting to initialize Distributed Transaction
>Coordinator.
>What causes it? How to fix it?
>(SQL Server 7.0, SP4, NT 4.0)
>Thank you.
>
>.
>

"Best" error messages contest

Server: Msg 1015, Level 15, State 1, Line 1
An aggregate cannot appear in an ON clause unless it is in a subquery
contained in a HAVING clause or select list, and the column being aggregated
is an outer reference.Why not to post the statement also?
AMB
"Ian Boyd" wrote:

> Server: Msg 1015, Level 15, State 1, Line 1
> An aggregate cannot appear in an ON clause unless it is in a subquery
> contained in a HAVING clause or select list, and the column being aggregat
ed
> is an outer reference.
>
>|||Cause it was querying a view, with a self aggregate join. It wouldn't make
sense.
Besides, that's not the contest.

> Why not to post the statement also?|||"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:%23iiDq5LTFHA.3840@.tk2msftngp13.phx.gbl...
> Server: Msg 1015, Level 15, State 1, Line 1
> An aggregate cannot appear in an ON clause unless it is in a subquery
> contained in a HAVING clause or select list, and the column being
> aggregated is an outer reference.
>
RAISERROR('Two guys walk into a bar...',0,1)|||Q: "Who Killed the Monkey in Raiders of the Lost Ark?"
A: "Bad Date."
"Chris Hohmann" <nospam@.thankyou.com> wrote in message
news:eUuKDXOTFHA.584@.TK2MSFTNGP15.phx.gbl...
> "Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
> news:%23iiDq5LTFHA.3840@.tk2msftngp13.phx.gbl...
> RAISERROR('Two guys walk into a bar...',0,1)
>|||"Michael C#" <howsa@.boutdat.com> wrote in message
news:uQjzyhOTFHA.2520@.TK2MSFTNGP09.phx.gbl...
> Q: "Who Killed the Monkey in Raiders of the Lost Ark?"
> A: "Bad Date."
> "Chris Hohmann" <nospam@.thankyou.com> wrote in message
> news:eUuKDXOTFHA.584@.TK2MSFTNGP15.phx.gbl...
>
Dilbert: What color do you want that database?
PHB: I think mauve has more RAM.