Jun 7, 2009 at 7:53 PM
Edited Jun 7, 2009 at 7:56 PM
I am a completely newbie to SQL 2005 Express Edition, or other of the MS SQL servers, trying to install Expressmaint in order to be able to do backup.
Using the following command from the documentation:
sqlcmd -S .\SQLExpress - i c:\expressmaint.sql
I see the following error and/or information?
Changed database context to 'master'.
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Ole Automation Procedures' changed from 1 to 1. Run the RECONFIGURE statement to install.
Stored Procedure created successfully
This is the second time I tried the above mentioned command, at first run the "changed from 1 to 1" was possible the text: "changed from 0 to 1" after my best recollection.
How do I run the "RECONFIGURE statement"?
Any help would be much appreciated.