Home Forums SQL Server 2005 Administering Adding SQL Server startup parameters from the command line RE: Adding SQL Server startup parameters from the command line

  • Joe Wagner (9/19/2011)


    Good day.

    We have the need to add the -g parameter to SQL Server Express instances that are deployed as part of our released product. The SSE instances run basically unattended, and using the SQL Server Configuration Manager GUI isn't an option, because the change has to be automated.

    I know where the registry entries are that contain the startup parameters, but I don't really like the idea of modifying them directly. I'll do it, though, if necessary.

    I've looked at sac.exe, but it doesn't seem to do what I want.

    Any suggestions would be appreciated.

    Regards,

    Joe

    How about using powershell... something like this: http://www.sqlservercentral.com/blogs/erichumphrey/archive/2011/03/31/change-sql-startup-parameters-with-powershell.aspx