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?
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?