title: Create a SQL Server database on a remote machine mdf file path issue
body: <p>I'm trying to create a MS Sql Server database on a database instance running on a remote machine.  When I'm doing so I need to be able to specify the path to the database (.mdf) file.  If I try to create a database in a folder which doesn't exist, SQL Server will just fail (wouldn't it be nice if it created the folder structure automatically).  </p>
  
  <p>Is there any way that I can create the folder path on the target machine in SQL before I try to create the database, or at least to determine what the default folder is for new databases in which I could safely create the new database file?</p>