MSDE - Start Databases

Hello

I'm using SQL Server 2000 - 8.00.760 Desktop Engine.

When the SQL Server starts, it just start databases master, model and tempdb. The databases that I have created don't start. They just start when I connect to them for the first time.

What I can do to start my own database when the SQL Server starts?

Thank you.

All databases are opened at startup if they are attached to SQl Server. If you have switched on the autoclose option, they are in common closed (but not stopped) after the last user disconnected.

jens Suessmeyer.

http://www.sqlserver2005.de

|||I did't switched on the autoclose option - it is off, but my database just start on first use, causing a delay on my application while it starts. When it is already started, I have no delay. I need start my database when SQLServer (MSDE) starts. Is there anything to do to start my database on start of SQLServer (MSDE)?|||

The Service is autostart, but my own databases just start when I connect to them to the first time.

Is there anything to do to auto start databases?

Thanks.

|||Are you sure you are using a MSDE database not a sqlserver express database. This sounds like you are using user instances which are only available after connecting the first time. Where do you actually administer the SQL server databases ? After starting the server do you see the entries in sysdatabase tables / views using SELECT * from sysdatabases ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I am using MSDE database. To administer SQL Server I use OSQL.

After start the server I ran SELECT * from sysdatabases. My own databases are listed.

|||If the databases are listed they should be available. use the SELECT name, mode, status,status2 from sysdatabases to check their current status. What is currently displayed ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I have three databases. They are listed and the databases master, model, msdb and tempdb are listed too.

After start SQLServer, the SELECT results the same values for my three databases: mode = 0, status = 1073741848 and status2 = 16777216.

Here, my own databases are not started. In the first connect to the database I has a delay, because they are not started.

Then, I connect to one and the value for status changes to 24. Now, it is started.

Any idea?