Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

2005 Online Index Rebuild using DMV Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2007 2:07 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 8:39 AM
Points: 1,157, Visits: 3,259
Comments posted to this topic are about the item 2005 Online Index Rebuild using DMV

Tommy

Post #408672
Posted Tuesday, December 11, 2007 6:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 23, 2014 4:45 AM
Points: 14, Visits: 217
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
Posted Tuesday, December 11, 2007 7:34 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, December 11, 2007 7:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 8:39 AM
Points: 1,157, Visits: 3,259
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 »

Add to briefcase

Permissions Expand / Collapse