I am trying to make a .SQL file to include in deplyments that can
create a database without use of an expressed path, since it is likely
to be different. I read the .SQL using osql from a install script. Is
there a way to ommit the path, or ask SQL to use its default? It seems
like there has to be a better way then editing the file during install
to change the path.
CREATE DATABASE [MyDB]
ON (NAME = N'MyDB_dat', FILENAME = N'(use default here?)' , SIZE = 62, FILEGROWTH = 10%)
LOG ON (NAME = N'MyDB_log', FILENAME = N'(Use default again?)' , SIZE = 146, FILEGROWTH = 10%)
I don't really know much about SQL script. Most of what I have is just generated.