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