Todd,

Thanks for the input. I ran the migration wizard and it looks like they all imported correctly. But I'm going to go thru them all tomorrow with a developer...

Mark,

I don't have any heterogeneous connections to Oracle/Sybase, etc. They are all native SQL connections and data load packages.

So you're saying that I could have a companion SQL 2000...

I agree with you statement about not being a huge fan of automatic fail-back until you've confirmed that everythign is fine on the server.

I'll take a look at the ALTER...

Aaron,

Thanks for your input.  It's greatly appreciated.  I'll take a look at what you suggested. 

What type of network issues could possibly cause this?  Any ideas?

What about a role change script to...

Grant,

Thanks for your input as well!  I'll try your suggestion about the "IN" and using a "JOIN" instead.

Gail,

Thanks so much for your wealth of input!  I will try your recommedations.

Jason,

Thanks for your speedy response.  I'll try to address your questions.

1.  My understanding is that the logic in this query should check duplicate transactions with the passed criteria since 12am of...

Ok, thanks to all of your guys input.  That's what i wanted to know if you could still perform "online" indexing operations while it was in 8.0 compatibility mode.

Thanks Russel!  And thanks for everyone else's input also. It was a "datetime" field BTW.  That's exactly what I'm looking for.  I'll try it out.  Much appreciated!

Here's the sample data:  '2006-12-06 10:26:27.170'

What I'd like to retrieve are the transactions that are in the following format:  '2006-12-06 10:26:27'

Excluding milliseconds as shown in this datetime example.  All records...

R2ro,

I made a mistake.  The last column is NOT a bit field, it's an int and it's not indexed.

DBA Dave

Thanks Remi!  I'll try this.  A developer created a Recurring Payment Service with .NET that processes the Recurring Payment transactions that are scheduled to process for the current date.  But in some cases,...

Remi,

I'm still having trouble with this logic.  The developer came back and gave me the following logic to use in an sproc:

If CancelDate <= getDate() then status = 3 '...

Thanks Remi!  I'll give it try. 

create trigger tr_upd_payment_bal

on ExtendedPayment

for update as

if update(completed)

begin

update ExtendedPaymentsInfo

set ExtendedPaymentsInfo.PaymentBalance = ExtendedPaymentsInfo.PaymentBalance - deleted.paymentamount

from ExtendedPaymentsInfo,deleted,ExtendedPayment

where deleted.extpaymentsinfoid = ExtendedPaymentsInfo.ExtPaymentsInfoID

and ExtendedPayment.extpaymentsinfoid = ExtendedPaymentsInfo.ExtPaymentsInfoID

end