Results 1 to 1 of 1

Thread: Error message

  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Error message

    Hi All,

    I am getting an error message when I run the following script:

    EXEC master.dbo.xp_sqlmaint ' -S servername -U user -P password -D ' + @DatabaseName + ' -PlanName OptimizationPlan -Rpt C:\MaintPlanRpts\OptimizationPlan.txt -DelTxtRpt 1DAYS -WriteHistory -RebldIdx 10 -RmUnusedSpace 25 10 '

    Here is the error message:
    Line 16: Incorrect syntax near '+'.

    What am I doing wrong?
    Last edited by inka; 03-22-06 at 18:04.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •