In Microsoft SQL Server Management Studio Express
If one clicks on "Databases"
One can select "New Database"
There "Database Name"
and "Logical Name" has to be entered.

Could you please tell me what the difference
between these two terms is?

Adrian.

Adrian,

In this context the logical name is the name of the .mdf file that will be
used to hold the database.

That name does not have to match the database name, but the default is to
use the database name with a ".mdf" extension.

Also notice that you can specify multiple logical files to hold the
database, but again the default is to have one logical file.

Kerry Moorman


Show quoteHide quote

database name and logical name
Concurreny with Datasets
Need starting advice...
1 Gig DataSet Limit Regardless of available physical memory?
DataReader and Master-Detail