Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kimberly Killian Are remote databases fragmented? Let's Defrag. RE: Are remote databases fragmented? Let's Defrag.

  • September 12, 2011 at 7:35 am

    #1380002

    I get this error in step 3

    Msg 102, Level 15, State 1, Line 167

    Incorrect syntax near 'schedule'.

    Msg 105, Level 15, State 1, Line 181

    Unclosed quotation mark after the character string '

    IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

    COMMIT TRANSACTION

    GOTO EndSave

    QuitWithRollback:

    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION

    EndSave:

    GO

    '.