database-create

Creating a database in SQL Server 2005

After installing SQL Server 2005, I tried to create a new database (command: create database database_name). But the message was an error: permission denied to create a database in 'master' database. My question is 1.) how to exit this master database and create a new database outside it, 2.) what is a master database. ...

Using NHibernate to execute DDL statements

How can I execute a DDL statement via NHibernate? To be clear, I don't want to auto-generate my schema from my mapping files. My DDL is stored in plain text files along the lines of: CREATE TABLE Foo (Bar VARCHAR(10)) GO CREATE TABLE Hello (World INTEGER) GO I want to cycle through these in order and execute each of them. I could jus...