I want to essentially duplicate a database.  I really only care about the schema.  I know how to export a database and create a .SQL type file from Visual Studio and have done it.  But I can't figure out how to create a new database and import the old one.  The data is irrelevant importing it or not doesn't matter to me.  I would like the resultant database to be under SQL Express. 

Thanks,

Chas 

in SSMS

Right Click your database -------------> Script DataBase as ----------------> Create To--------------------> New Quer editor Window

This will create the SQL Script for your database

Now you can change the database name in this SQL Query to create a new database with the same schema

When open the New Query editor window I get

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Script failed for Database 'C:\USERS\CHARLES\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MC4HA\APP_DATA\MC4HADATA.MDF'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Script+Database&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

Database 'C:\USERS\CHARLES\DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\MC4HA\APP_DATA\MC4HADATA.MDF' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476

The help link just goes to a page that says "no further explanation".  How do I open the SQL server error log?  
 

.master.dbo.xp_readerrorlog

Or you can also seee windows application log