I have resovled the issue by declaring the cursor insensitive. Thanks every one for their input.

-- resolution

DECLARE dbbackup_cursor INSENSITIVE CURSOR FOR

SELECT mst.name, mst.database_id FROM SYS.DATABASES mst WITH...

I am hoping this has something to do with it but earlier in the same day our system dept. applied MS patches.

I am scheduling a reboot and hopefully everything will...

the problem is the transaction log is sized at 12 gig and 10 gig of it is used. In simple recovery it should check point and clear when completed the...

Thanks however I am trying to append getdate to the end then do as you described. I am struggling with getdate(0) conversion I guess.

Thanks all for the reply.

So we were just discussiing where does the out of row data get stored.

Is it memory or disk ?? It sounds like disk.

I am approaching...

YES the one oracle table has 2 PK keys.

SQL server side where it deletes from  18 tables does has a primary key on every table but maybe half on the same...

Thanks for the info from all. I think the 30 second timeout via the client is our issue and we will pursue that.

Auto Shrink is definately off.

The column is blank.

They say this is a canned app and they cannot modify the code.

Thanks Alot. I was  aware of that stored procedure but I like the thought for testing the time between cursor loops. I will do that?

Second question.  The dbase is in full...