Problem installing Expressmaint

Jun 7, 2009 at 7:53 PM
Edited Jun 7, 2009 at 7:56 PM

Hello all:

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.

Regards
Erik

Coordinator
Jun 7, 2009 at 9:42 PM

Hi Erik,

The messages are just informational, the code runs RECONFIGURE for you so there's no need to do anything. You have successfully installed the stored procedure so you will now be able to execute it as per the examples

Cheers,

Jasper Smith

Jun 8, 2009 at 10:57 AM

Hi Jasper,

Thank you very much for your prompt reply.

Regards
Erik