MSDE Setup and first database

I'm deploying MSDE with a desktop app (windows forms .net).
after installing MSDE, how do I create the database for the application?
I cannot provide a createdb.sql script to the user because there is no
queryanalyzer or similar tools.
How can I run the create query from the setup? or what is the recommended
method for doing this?
Thank You!
Hi,
Give a batch file to create the database. All you have to do is double click
the batch file. batch file should contain:-
OSQL -Usa -Ppassword -S servername -Q'Create database
dbname' -o'c:\createdb.log'
Save the command inside a .BAT file and send to client side to create the
database. Instad of giving the -Q parameter you
can also input a .SQL file which contans sequence of TSQL commands.
Thanks
Hari
SQL Server MVP
"Harley" <harleyobrienAThotmailDOTcom> wrote in message
news:E3273FC0-ADE4-47B1-9F3D-8DEC479E3341@.microsoft.com...
> I'm deploying MSDE with a desktop app (windows forms .net).
> after installing MSDE, how do I create the database for the application?
> I cannot provide a createdb.sql script to the user because there is no
> queryanalyzer or similar tools.
> How can I run the create query from the setup? or what is the recommended
> method for doing this?
> Thank You!

MSDE Installation

When I install MSDE (MSDERelA) it installs fine, but it doesn't start the
service.
I am deploying this to a large number of computers and I don't want to have
to require them to reboot or go into the component services console in order
to use the database.
It there a why to start the service as soon as it installs without user
having to go into the services console or reboot?
Hi Lance,
From your descriptions, I understood that you MSDE instance will not be
launched unless you reboot your box or go into the services console. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Based on my scope, after the installation, the service is started by
default. Look in Task Manager and you should see the service running. You
can use any application that connects to the service or you can issue osql
commands to work with the service.
Are there any error log shown during the setup? If you are installing the
MSDE stand-alone, will the service be started?
Anyway, if the service is not started by default, you could try to start it
with a DOS command "net start <Service Name>" in your application.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

MSDE Installation

When I install MSDE (MSDERelA) it installs fine, but it doesn't start the
service.
I am deploying this to a large number of computers and I don't want to have
to require them to reboot or go into the component services console in order
to use the database.
It there a why to start the service as soon as it installs without user
having to go into the services console or reboot?Hi Lance,
From your descriptions, I understood that you MSDE instance will not be
launched unless you reboot your box or go into the services console. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Based on my scope, after the installation, the service is started by
default. Look in Task Manager and you should see the service running. You
can use any application that connects to the service or you can issue osql
commands to work with the service.
Are there any error log shown during the setup? If you are installing the
MSDE stand-alone, will the service be started?
Anyway, if the service is not started by default, you could try to start it
with a DOS command "net start <Service Name>" in your application.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

MSDE Installation

When I install MSDE (MSDERelA) it installs fine, but it doesn't start the
service.
I am deploying this to a large number of computers and I don't want to have
to require them to reboot or go into the component services console in order
to use the database.
It there a why to start the service as soon as it installs without user
having to go into the services console or reboot?Hi Lance,
From your descriptions, I understood that you MSDE instance will not be
launched unless you reboot your box or go into the services console. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know:)
Based on my scope, after the installation, the service is started by
default. Look in Task Manager and you should see the service running. You
can use any application that connects to the service or you can issue osql
commands to work with the service.
Are there any error log shown during the setup? If you are installing the
MSDE stand-alone, will the service be started?
Anyway, if the service is not started by default, you could try to start it
with a DOS command "net start <Service Name>" in your application.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!