Thanx Terry for reply.

System is doing good so far, but I feel if we could change the compatibility. It will generate good compile and execition plan and will work better.

Long back old DBA's migrated to 2000, but the tables still has Ansi NULL off (other settings as well). was thinking to improve the performance and efficiency of the system but looks like it will be a BIG task includes application level changes... so I also think its better to go as it is going... and try to handle what all is possible(As business is not ready to invest more on this).

Thanx

Vinay