public static string GetCreateDatabaseScript (string databaseName)
{
return string.Format (@"USE master
CREATE DATABASE [{0}]
ON PRIMARY (
Name = '{0}_Data',
Filename = 'C:\Databases\{0}.mdf',
Size = 10MB
)
LOG ON (
Name = '{0}_Log',
Filename = 'C:\Databases\{0}.ldf',
Size = 10MB
)", databaseName);
}