adInteger and adParamOutput... are meaningless in asp.

You must replace them with their equivalent int value.

Ex adParamInput = 1.

There's also a workaround where you must include a vb file but I...

You could also use this is the index is not the primary key :

Select * from dbo.SysIndexes where id = object_id('TableName') and name = 'IndexName'

How does the sliding window method work?

They are accepted to be user friendly, but mostly because they have to be compatible with other Database systems that allow this.

Wouldn't it be even simpler to have a column...

I'm wondering if you could use a different desgin in this case. Would it be possible to move that info in another table like OpenHoursType or something like that...

Shouldn't the second exec read? :

ALTER DATABASE [?] SET READ_WRITE

oops.. I didn't see the if Update(complete). Do the rows that need to be modified change if that column is not updated?..

Anyways you get the idea. Msg me if...

create trigger tr_upd_payment_bal

on ExtendedPayment

for update as

if update(completed)

begin

update ExtendedPaymentsInfo

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

, ExtendedPaymentsInfo.PaymentStatusID =

CASE WHEN CancelDate <= GETDATE() OR CONVERT(varchar(10), PaymentEndDate, 111) = CONVERT(varchar(10), getdate(), 111) THEN 3...

Hehe, you guys are sneaky .

it's pretty easy to do but it'd be better if you could post the rest of the trigger so we could put the code into its rightfull place instead of...

The words "slow typers" comes to mind here .

Wow A guru suggesting a cursor... that must be a first. Is the cursor more effective in the case than the set solution? Is it faster because only 1...

Well the first thing I would do is to tell the programmers to stop dropping the triggers for no reason and show them how to use those commands :

--disable...

Happened to me and at least 5 others that complained about something very similar... it's probabely the session that's ending on the server or something like this (haven't worked with...

What was the problem?

Please post so that others that find this thread can also fin a solution.