"Tom Moreau" wrote:

> Check out "Starting SQL Server Manually" in the BOL.
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON   Canada
> www.pinpub.com
> ..
> "Ed" <E*@discussions.microsoft.com> wrote in message
> news:84BB14EF-4241-4426-B4F1-16C28F2B618A@microsoft.com...
> Hi,
>   Is there anyway I can change the startup parameter without using
> enterprise manager for -dC:\Program Files\Microsoft SQL
> Server\MSSQL\data\master.mdf
> -dC:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.mdf
>
> Thanks
> Ed
>
>

"Ed" <E*@discussions.microsoft.com> wrote in message
news:47C9FECC-0151-4862-A2A4-C7074F13A1E8@microsoft.com...
> Thanks,
>  But I would like to know where the startup parameters stored.  Is it in a
> specific file under c:\Program Files\MS SQL Server\......
>
> Ed
>
> "Tom Moreau" wrote:
>
>> Check out "Starting SQL Server Manually" in the BOL.
>>
>> --
>>    Tom
>>
>> ----------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON   Canada
>> www.pinpub.com
>> ..
>> "Ed" <E*@discussions.microsoft.com> wrote in message
>> news:84BB14EF-4241-4426-B4F1-16C28F2B618A@microsoft.com...
>> Hi,
>>   Is there anyway I can change the startup parameter without using
>> enterprise manager for -dC:\Program Files\Microsoft SQL
>> Server\MSSQL\data\master.mdf
>> -dC:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.mdf
>>
>> Thanks
>> Ed
>>
>>

"Dan Guzman" wrote:

> The default startup parameters are stored in the registry.  If you don't
> want to use EM, these are also exposed through SQL-DMO.  You could also
> modify the registry entries directly, but at your own risk.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Ed" <E*@discussions.microsoft.com> wrote in message
> news:47C9FECC-0151-4862-A2A4-C7074F13A1E8@microsoft.com...
> > Thanks,
> >  But I would like to know where the startup parameters stored.  Is it in a
> > specific file under c:\Program Files\MS SQL Server\......
> >
> > Ed
> >
> > "Tom Moreau" wrote:
> >
> >> Check out "Starting SQL Server Manually" in the BOL.
> >>
> >> --
> >>    Tom
> >>
> >> ----------------------------------------------------
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >> SQL Server MVP
> >> Columnist, SQL Server Professional
> >> Toronto, ON   Canada
> >> www.pinpub.com
> >> ..
> >> "Ed" <E*@discussions.microsoft.com> wrote in message
> >> news:84BB14EF-4241-4426-B4F1-16C28F2B618A@microsoft.com...
> >> Hi,
> >>   Is there anyway I can change the startup parameter without using
> >> enterprise manager for -dC:\Program Files\Microsoft SQL
> >> Server\MSSQL\data\master.mdf
> >> -dC:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.mdf
> >>
> >> Thanks
> >> Ed
> >>
> >>
>
>
>