Post reply

Reindex script alteration

  • September 9, 2013 at 7:35 am

    #1648541

    Doesn't when I test. It does however throw

    Msg 16924, Level 16, State 1, Line 69

    Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.

    as only one of the two FETCH statements was modified.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 9, 2013 at 7:52 am

    #1648546

    GilaMonster (9/9/2013)

    Doesn't when I test. It does however throw

    Msg 16924, Level 16, State 1, Line 69

    Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.

    as only one of the two FETCH statements was modified.

    Its now working as expected. Strange how the print won't work though.

    Appreciate your help!

    What size of an index would you say is too small to even worry about?

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply