The MS-SQL 2000 only using 2G RAM by default. If there is a SQL server with huge RAM, than maybe we could increasing the RAM amount of SQL by open the AWE switch. Here is the method that open it. Open AWE switch sp_configure 'show advanced options...
yonny.yoning.com1 min readNo responses yet.