Check to see if DB is already Attached

[DroopyA]

How can I tell if a Database is already attached to SQL/MSDE or not?

I'm creating a new install for a custom aplication that uses SQL as the database and I'm trying to figure out the best way to attach the database. One way is to attach it durring the install... another option is to have the application check to see if the database is attached and if it's not attach it when it runs.

How can I tell if MyDatabase.mdf has already been attached to SQL Server/MSDE or not? Is it better to attach it durring the run of the .exe or should I attach the database durring the install?

 

[nigelrivett]

You can look at master..sysaltfiles but I think that doesn't always contain all the databases.

Looping through all the databaes in sysdatabases and looking at sysfiles in those databases should do it.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[DroopyA]

Thank you! I guess I'm better off attaching it durring the install. Looping through all of the databases is far too much work to be done every time you launch my program.