Hi,

I want to create a new database from .net . How should I do that?

what is a connection string when there is no database ?

Thanks

Use SMO to create a database, rather than crafting your own DDL.

using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;

Server server = new Server(@"locahost\sqlexpress");
Database db = new Database(server, "YourDatabaseName");
db.Create();

You will also need to add references to the SMO assemblies to your project.

Give that a try.

 You'll need to connect to the database server with the database as master database.

Check out the code project article which explains this concept here.

http://support.microsoft.com/kb/305079

http://www.codeproject.com/KB/aspnet/SQLDb_Using_Aspnet.aspx

malcolms:

Use SMO to create a database, rather than crafting your own DDL.

using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;

Server server = new Server(@"locahost\sqlexpress");
Database db = new Database(server, "YourDatabaseName");
db.Create();

You will also need to add references to the SMO assemblies to your project.

Give that a try.

Gee, that response looks familiar somehow...

 Yes, I saw this reply somewhere recently L)