thanks bro, i will take a full backup and uinstall sql 2008.

will share the results, as soon as its done.

the only problem is that what all changes made to 2008 is reflected on the 2012 DB,

u try creating a new Test Db on 2008 and u open 2012 management...

removing the 2008 from the applications will not affect the 2012 right, its a live server.

how about removing the 2008 completely from the add or remove programs?

The whole tool sets for 2008 and 2012 are existing not just the management studios

and while running the @@version on both 2008 and 2012 will give the result,

...

Thanks for replying Rudy 🙂

See the server is dedicated for sql only, but an anti virus(symantic) is installed which is also utilizing memory like 38gb.

-i used perfmon...

.