create msde database

[153]

Does anyone know how to create an msde database programmatically?

 

[bboffin]

Because MSDE is just a slightly crippled version of MS SQL Server if you use a connection to a DB Server that is actually an MSDE server you can use all the standard MS SQL features to create a database such as the T-SQL command CREATE DATABASE.

AFAIK MSDE doesn't restrict the number of databases per server, just the maximum size of each DB (2GB?)



Bob Boffin

 

[chiph]

Yup, just issue CREATE DATABASE and CREATE TABLE statements.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[153]

Thanks for reply.

How should I write the connection string? (connection to which database?)

 

[chiph]

You would connect to the 'master' database on the server prior to sending your create database commands.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[153]

thanks,

I will try it!

 

[153]

Thanks...

It works fine.

Thanks for all of your help.