2005 Online Index Rebuild using DMV

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tommy Bollhofer » 2005 Online Index Rebuild using DMV

2005 Online Index Rebuild using DMV

Rate Topic

Display Mode

Topic Options

Author

Message

Tommy Bollhofer

Posted Tuesday, October 09, 2007 2:07 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:43 PM
Points: 1,148, Visits: 3,148

Comments posted to this topic are about the item 2005 Online Index Rebuild using DMV

Tommy

Post #408672

sbarlow

Posted Tuesday, December 11, 2007 6:39 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, November 06, 2012 10:41 AM
Points: 14, Visits: 201

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'.

Post #431749

SQL_EXPAT

Posted Tuesday, December 11, 2007 7:34 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 27, 2012 9:09 PM
Points: 136, Visits: 383

me too... lots of errors.

-- cranfield, DBA

thanks

SQL_EXPAT

Post #431784

Tommy Bollhofer

Posted Tuesday, December 11, 2007 7:38 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:43 PM
Points: 1,148, Visits: 3,148

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

Post #431789

« Prev Topic | Next Topic »

Permissions