I tried with AND condition. Also, updatestats and again tried to run the script. Still same result !!!

I updated the statistics but same result. it is stopping at UPDATE statement.

Table Rows

#tempCDI369

CDI5642

-- The below statisitics i gathered when i manually executed each...

400 records odd.

How would the statistics and indexes would help us on this regard?

Any ways, i will check with it.

Temp table is pretty straight

CREATE TABLE #temp

...

Adding to this, status codes are same based in the INNER join.

What if would make the difference if am updating the same value. Why it is hanging. What if...

Good to see a response.:-)

The script was already on production from quite a long time.

Changing the code requires again approval and lot of stuff.

Before that , i have a...

I have tried WITH NOLOCK option still remains the same.

Can anybody figure out what is the problem ?????

I beleive databases are related to only "master" databases and nothing to do with server renaming.

We dont have problem if we take the backups before server migration.

But in the...

Here is something to move forward.

I will keep u posted more on deeper code - level , once i get clarity!!!!

Seems like there is a problem with Web server...

Thanks for all your kind suggestions.

Thank You!!! 🙂

Last question.

Which one of the above mentioned is normally used in most scenarios?

Again, we post a down time to application users during the failover and perform either of the above...

Makes sense. I will collect the info and keep you posted.

Thanks both! 🙂

Hi George,

Would like to know more on this. This is what i understand. Correct me if am wrong.

The primary and Secondardy has their own static ip addresses and hostnames.

Are you...