October 9, 2007 at 2:07 pm
Comments posted to this topic are about the item 2005 Online Index Rebuild using DMV
Tommy
Follow @sqlscribeDecember 11, 2007 at 6:39 am
Here is the error I get.
Msg 102, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 82
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 92
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 96
Incorrect syntax near '?'.
Msg 137, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 106
Must declare the scalar variable "@numreindexes".
Msg 319, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 106
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Msg 102, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 110
Incorrect syntax near '?'.
Msg 137, Level 15, State 2, Procedure usp_OnlineIndexRebuild, Line 110
Must declare the scalar variable "@recount".
Msg 137, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 112
Must declare the scalar variable "@tabname".
Msg 137, Level 15, State 2, Procedure usp_OnlineIndexRebuild, Line 117
Must declare the scalar variable "@indname".
Msg 137, Level 15, State 2, Procedure usp_OnlineIndexRebuild, Line 119
Must declare the scalar variable "@recount".
Msg 137, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 122
Must declare the scalar variable "@numreindexes".
Msg 319, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 122
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Msg 102, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 125
Incorrect syntax near '?'.
Msg 137, Level 15, State 2, Procedure usp_OnlineIndexRebuild, Line 126
Must declare the scalar variable "@recount".
Msg 137, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 128
Must declare the scalar variable "@tabname".
Msg 137, Level 15, State 2, Procedure usp_OnlineIndexRebuild, Line 133
Must declare the scalar variable "@indname".
Msg 137, Level 15, State 2, Procedure usp_OnlineIndexRebuild, Line 135
Must declare the scalar variable "@recount".
Msg 102, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 141
Incorrect syntax near '?'.
Msg 156, Level 15, State 1, Procedure usp_OnlineIndexRebuild, Line 153
Incorrect syntax near the keyword 'FOR'.
December 11, 2007 at 7:34 am
me too... lots of errors.
-- cranfield, DBA
thanks
SQL_EXPAT
December 11, 2007 at 7:38 am
Appears to be an issue with the WYSWYG editor in SSC. I've sent an e-mail to Steve Jones to see if I can get a link on the page to download the original SP. In the interim, please feel free to e-mail me at tbollhofer2@gmail.com and I will send a copy along.
Thanks.
Tommy
Follow @sqlscribeMay 10, 2016 at 9:24 am
Thanks for the script.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply