What is the query plan of the query on server02?

Are both server collation compatible? (is the collation compatible option on the linked server switched on or is there a specific...

If you run the package it runs under your security account.

If it runs as a job it runs under the sql server agent account.

My first guess was that sql server...

What is the security account that SQL Agent uses? Local System Account or a domain account?

Sometimes it can happen that views are mapping the wrong fields. Especially if the basetables were changed.

Is it possible to alter the view slightly so it is refreshed?

One option is a combination of SQL Agent & a job checking the event logs + SQL mail but that would be odd to report SQL Agent errors.

Perhaps a homewritten/3th party...

All jobs are executed under the SQL Agent account. Does it has sufficient permissions?

Could you post your actual code (maybe changing some names)?

Actually, my SP just having 02 cursor

where the outer cursor will pass some

info to the inner cursor to process

and update some...

Fillfactor=when creating the index

example index node can point to 1000 records before a new node needs to be constructed

fillfactor 100%=all pointers point to actual data, if a new record is...

you can also add a second logfile for your tempdb

one other thing is let us say i run the upate statement itself in a begin tran/rollback tran even then everything is reset and app services start working fine. but...

You're welcome.

I haven't tested the differences as most of my stored procedures are quite static.

You can trace all recompilations with sql profiler or an indication using the performance monitor.

I'm still somewhat suspicious to the low amount of free space.

What happens if you set autogrow size to 100 mb instead of 10%.

Is there something in the sql server logs...

It could be that your database or logfile fails to autogrow.

10% of 7030MB =703 MB

available space:693MB ->not enough

is available space in your post  space free on the hard disk or in the database itself?

fast_forward read_only cursor would be the fastest

see fast forward only cursor in the books online