SQL Server 2005: A database on a different drive?
I think I know the answer to this, but I want to see if anyone has a different one...
I have a database (well, I have a spec, I'm not creating it until I know the answer to this question) I'd like to create on a flash drive. Is this possible? It seems to me that one has to create all databases from a given SQL Server instance in the same directory...
(Basically, I'd like to be able to access the database from four SQL Server instances on two different networks and one non-networked computer-- because those are the locations I'll be programming the front-end app.)
I have a database (well, I have a spec, I'm not creating it until I know the answer to this question) I'd like to create on a flash drive. Is this possible? It seems to me that one has to create all databases from a given SQL Server instance in the same directory...
(Basically, I'd like to be able to access the database from four SQL Server instances on two different networks and one non-networked computer-- because those are the locations I'll be programming the front-end app.)
