Hello,
We're upgarding ... new install ... MSSQL2005 S.E/RTM
When creating a new database using mssql Server Man Studio, why is everything editable except "Filename" ie: it's blank with a blue/greay fill ... why can I edit the logical name but not Filename?
ie: Create db called db ... Logical Names = db and db_log and the OS files (File name) created by default are db.mdf and db_log.ldf.
I would like to remove the "_log" so the OS files are db.mdf and db.ldf.
Is there a way? We use to be able to specify this in earlier MSSQL versions.