Hi EdVassie,

Actually, I would have to disagree with the idea the SQL Server 2005 does not have the lock memory/fix memory option.  Because i have installed SQL Server 2005 on...

sorry yes, cpu was a typo, sql server is using half of memory. i have 1G and SQL can not use all of that because this is not a machine...

Hi john,

thanks for your quick response. yes we see that sql server is using half the cpu and we can not afford for that to happen right now so...