"Jens Süßmeyer" wrote:

> Comments inline.
>
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
> "steven scaife" <stevenscaife@discussions.microsoft.com> schrieb im
> Newsbeitrag news:399E4B40-6312-423F-99B1-D3566EA9BEA6@microsoft.com...
> >I am developing an application that will use msde or SQL sevrer depending
> >on
> > if they are in the office or workign on the road. If they are on the road
> > they currently have MSDE installed by a different program. I also want to
> > use the msde service to run my database.
> >
> > is it possible to run two databases on the same PC?
> Yeah, you are only stuck in to one instance.
> > if it is do I need to know the sa password for msde? if i do is there a
> > way
> > around it, I doubt that the company whos program runs on msde would want
> > me
> > knowing the sa password
> if you got windows auth. activated you can easily log on to the msde
> with an administrive account, they are usally members of the system
> administrator group, if they disabled it, you can reenable that via:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\Mi­crosoft\
> MicrosoftSQLServer\<instance_n­ame>\MSSQLServer\LoginMode
> auf "1" (Windows Auth)
>
> http://www.microsoft.com/sql/t­echinfo/tips/administration/Ma­y3.asp
>
>
> >
> > I have my database scripted in 3 sql files and I know that I will have to
> > use oSQL to execute them
> >
> > If any one can point me how to do it or provide sample code I would be
> > very
> > grateful
>
> You can call external scripts via the switch -i
>
> OSQL -iC:\Test.sql
>
> > cheers
>
>