In my setup package, I use sql scripts to create databases and it went ok. I also have scripts to detach them. However, how can I delete these physical database files?
Another problem is that at the moment I hardcoded the paths for these db files, for example: CREATE DATABASE [ASPNETDB] ON (NAME = N'ASPNETDB_471e9d426f5c4adea569c397dcf32bed_DAT', FILENAME = N'c:\pipeline\aspnetdb.mdf' , SIZE = 10, FILEGROWTH = 5) LOG ON (NAME = N'ASPNETDB_TMP_log', FILENAME = N'c:\pipeline\aspnetdb_log.ldf' , FILEGROWTH = 10%)
Is there any chance that sql scripts can take parameters so that the users can choose where to put these db?
