Database.Create()

I'm looking at using SQL Server SMO to create databases dynamically from a code generator that I'm writing that will use UML class diagrams of business entities as the input metadata.

Is there a sample for using the Microsoft.SqlServer.Management.Smo.Database class, and specifically the Create() method.

When I try a simple call to Create() after merely assigning the database a name, I recieve an inner exception stating:

"You cannot perform operation Create on an object in state Pending."

Any help would be greatly appreciated.

- Doug

[629 byte] By [DougHolland] at [2008-1-25]