Hi Karl,

Thanks for the quick answer! But I still don't understand. On my machine, only one application is using sqlServer. After the application is shutdown for a long time, there...

There are 100 tables in my database . A  view, named SV,is already created to record map information between table and columns. The view has 3 fields : Table_Name,Column_Name,Column_Type

  For some reason ,I need to...

But I wonder if I can use 2 Cursors to make a dynamic "select" in QueryAnalyzer.

Because I do not want write any program  except for SQL script.

Is it possible ?

Three steps.

1.Set database offline (Clear connections)

2.Detach database

3.Delete mdf and ldf files.

I used to use drop command .Later on I found it can not fit all situations.For example, if database doesn't exist in system tables...

Hi Noel, many thanks for your help!

Yes. I have made the change to alter database online after attaching it.

And until now I have not reproduced this problem. Since this issue...

The problem occurs at times. Last time when it occured,I checked the log message and found after waiting for 10 minutes, the database is...

Hi All,thanks for your help!

The codes mentioned above will be executed during installation of a system-level application,which will drop old database at first, then copy the pre-built database file to dest directory...

NO. It is sqlServer2000.

Thanks a lot !

I am still confused that why sometimes after executing sp_attath_single_file_db,the database status could be "Offline".In my understanding,the database should  be "Online"