My Apologies,

By memory i mean Memory to be utilized by SQL Server 2005/2008 . if you didnot set AWE, by default it is going to use the same default...

set awe enabled to 1

then set your memory

Hi ,

I faced the same problem with one of database when i joined new company, first think if its real urgent , figure out the process(Sp's ) which...