Help: Can I load all table content to the memory during SQL server Startup?

Dear Sir,
I use SQL 2000 server. I want to load all the table content to the
memory the SQL server startup.
How can I do that?
My computer has 2 G RAM. The total space of the databse is 1G.
I have set the mininum memory is 1G (in dynamic configue SQL memory) in SQL
server and check the "Reserved physical memory for SQL server". But no all
data load into the memory during SQL server startup.
I just know that if I write a SQL statement to request records, these
records will be load into memory.
SO, I think it is not a good method to select all tables once after the SQL
server just startup.
Thank you for your help!
--
Regards,
Anthony LamAssuming you really want to do this, create a stored procedure which reads the rows and mark it as a
startup proc (sp_procoption).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"AA" <anthony@.jadeflex.com> wrote in message news:%23ARNLe$gDHA.3272@.tk2msftngp13.phx.gbl...
> Dear Sir,
> I use SQL 2000 server. I want to load all the table content to the
> memory the SQL server startup.
> How can I do that?
> My computer has 2 G RAM. The total space of the databse is 1G.
> I have set the mininum memory is 1G (in dynamic configue SQL memory) in SQL
> server and check the "Reserved physical memory for SQL server". But no all
> data load into the memory during SQL server startup.
> I just know that if I write a SQL statement to request records, these
> records will be load into memory.
> SO, I think it is not a good method to select all tables once after the SQL
> server just startup.
> Thank you for your help!
> --
> Regards,
> Anthony Lam
>