<div>
Enclose special characters with [] or &quot;&quot;&nbsp;like this:<br />
<br />
alter index [index-name] on databasename.dbo.tablename<wbr /> reorganize ;
</div>


Enclose special characters with [] or "" like this:

alter index [index-name] on databasename.dbo.tablename reorganize ;

<div>
already tried that, other than that do u find any syntax error there?
</div>


already tried that, other than that do u find any syntax error there?

<div>
In SQL Server 2000, use this<br />
<br />
DBCC DBREINDEX (&quot;dbo.tablename&quot;, [index-name],80);<br />

</div>


In SQL Server 2000, use this

DBCC DBREINDEX ("dbo.tablename", [index-name],80);


<div>
<div class="content wysiwyg-content">
Hi All,<br />
I am trying to reorg and Index using this below script<br />
<br />
alter index index-name on databasename.tablename<br />
reorganize ;<br />
<br />
Is this syntax right, As it says incorrect syntax near index?
</div>
</div>


Hi All,
I am trying to reorg and Index using this below script

alter index index-name on databasename.tablename
reorganize ;

Is this syntax right, As it says incorrect syntax near index?

REORG AN INDEX IN SQL 2000

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.