September 19, 2011 at 9:32 am
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
September 19, 2011 at 1:38 pm
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
September 19, 2011 at 3:24 pm
Thanks for the reply.
Unfortunately, our deployments don't have Powershell yet. I'll keep this in mind for later.
Can this be morphed into something that would be called from a VBScript/bat file, that uses WMI?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply