> What we need is something very simple: use a SQL statement to create a
> database and let the server decide where to store it. We want to pass a
> database name (only the name, not a file name) and expect the server to
> create the database in its own folder. Something as simple as:

I think something like this would be useful or some other way to
automatically register the location of the database. I'm going to start
using aliases for now.

Anyone ever try to explain how to specify the database path location in
the connection string to someone and somehow, they always think they are
supposed to enter a UNC share on the server. Sometimes it takes a few
tries of explaining that you are telling the database server where to
find the database file on ITS harddrive :)

--

Warm Regards,

Lee