Create DataBase and trigers, logins etc... in instalation...HELP

Hi,
My aplication use MSDE and,
I need create database, trigers etc... in instalation of MSDE.
What I had use: osql, callback, api...
How I do this...
Any idea?
Thanks.
Hi,
MSDE will not provide the normal GUI utilities. So you have to do all TSQL
statements using the utility OSQL from comamnd prompt.
OSQL -Usa -Ppassword -Sserver (enter)
1>create database <dbname>
2>go
1> create trigger abc_tri on cust for insert as select custno from cust
2>go
The list goes on.. For command syntax you can refer SQL server books online.
Note:
Now microsoft is providing web based free tool to administer the database.
Using this you can do coding as well
as administration stuff like creating database, increasing size, creating
tables, triggers , proceduers ...ect...
Download webadmin tool from below site.
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
Thanks
Hari
MCDBA
"Vanda Forti" <tforti@.terra.com.br> wrote in message
news:OrhhPApZEHA.212@.TK2MSFTNGP12.phx.gbl...
> Hi,
> My aplication use MSDE and,
> I need create database, trigers etc... in instalation of MSDE.
> What I had use: osql, callback, api...
> How I do this...
> Any idea?
> Thanks.
>
|||Hi
you can also have a look to this web based GUI : myLittleAdmin
http://www.myLittleTools.net/mla_sql
Hope this helps !
Elian Chrebor
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin : online MS SQL manager
// http://www.mylittletools.net
// webmaster@.mylittletools.net
Hari Prasad typed:
> Hi,
> MSDE will not provide the normal GUI utilities. So you have to do all
> TSQL statements using the utility OSQL from comamnd prompt.
> OSQL -Usa -Ppassword -Sserver (enter)
> 1>create database <dbname>
> 2>go
> 1> create trigger abc_tri on cust for insert as select custno from
> cust 2>go
>
> The list goes on.. For command syntax you can refer SQL server books
> online.
>
> Note:
> Now microsoft is providing web based free tool to administer the
> database. Using this you can do coding as well
> as administration stuff like creating database, increasing size,
> creating tables, triggers , proceduers ...ect...
> Download webadmin tool from below site.
>
>
http://www.microsoft.com/downloads/d...039A798-C57A-4
19E-[vbcol=seagreen]
> ACBC-2A332CB7F959&displaylang=en
> Thanks
> Hari
> MCDBA
>
>
> "Vanda Forti" <tforti@.terra.com.br> wrote in message
> news:OrhhPApZEHA.212@.TK2MSFTNGP12.phx.gbl...