Unfortunately I live in the world of Change Management :angry: where even a fart needs the correct approval, testing and lead-time. Adding new jobs willy-nilly isn't possible.

This all needs to...

unfortunately not - we upgraded the app recently and the isolation level was necessary as part of that version change. rather strangely there are 3 instances and only 1 has...

Yeah, Autosys software and anything scheduled 'should' be run that way :rolleyes:

I had glanced at OUTPUT previously but discounted it as it didn't seem appropriate, but have tried to incorporate...

thanks for replies so far. there just doesn't seem to be any way of using historical data in SQL to find the culprit. i guess that it will take some...

who'd have thought something so simple could have created as much debate :-), and thanks for all the input so far. As a bit more explanation:

This relates to a logging...

Have looked at Cold Coffee's solution and it works to an extent, but it will only work when the notes are as they should be. I can't expect that to...

OK, specifically this stumps me:

If this is my table:

ID Date Description

--------------------------------

221 1/11/12 09:00 Note1

222 1/11/12 09:02 Note2

225 1/11/12 09:08 Note3

678 1/11/12 10:00 Note4

898 1/11/12 10:33 Note5

How do I cross-reference that...

Not sure I explained very well...

If I have this:

ID Date Description

--------------------------------

221...

OK, a rundown of the sizes are:

Overall Data Drive: 255GB with 132GB Free

*Half of the database datafiles are located here, the rest on a mounted volume of 255GB with 93GB...

sounds like we are pioneers! 😎

so what is the standard method for having the trigger fire multiple rows if I ran 'delete from table_123 where item_1 between 5 and 55'?

thanks for the advice guys.

just to clear up the cursor/trigger issue (:blush:) it was along these lines, fairly standard i thought:

[font="Times New Roman"]SET NOCOUNT ON

DECLARE c_item CURSOR FAST_FORWARD...

ACinKC (4/20/2012)

Hopefully it would either have those two steps wrapped in a transaction or drop the table first, then...

hi sean,

sorry - its difficult to describe.

the vendor told me of a SP which should be running (but isn't) and it does two things:

1) delete from table_A where ID =...

as a followup question since there have been no replies :angry:

which of these two scenarios will be quickest:

1) run stored procedure which will select a bunch of rows to be...

hmmm, me too :rolleyes: they are just advising against it. i have experienced odd results within the application in question, where SQL native complains about a missing stored procedure and...