|
Home > Archive > MS SQL Server > November 2006 > SQLServer 2005 Reorganize Index error.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQLServer 2005 Reorganize Index error.
|
|
| sqldba 2006-11-08, 7:12 pm |
| Seems odd to me that I can't find anything on this. SQLServer 2005 Dev
running on Windows 2003 EE. Following this path from Management Studio
click databases (select user db) > Tables > Indexes > Right click Index
and select Properties. Select Fragmentation then click Reorganize index
at the bottom of the window. I get the following error: "'fillfactor is
not a recognized ALTER INDEX REORGANIZE option. (Microsoft SQL Server,
Error: 155)"
This is nothing more than a non-clustered index.
Scripting it out it shows:
USE [UserDB]
GO
ALTER INDEX & #91;ncx_table1_Col1]
ON [dbo].[table1] REORGANIZE WITH (
FILLFACTOR = 90, LOB_COMPACTION = ON )
GO
| |
| Tibor Karaszi 2006-11-08, 7:12 pm |
| Seems to be a bug in SSMS. I just reproduced it. If you created an index with a specified
fillfactor, SSMS tries to execute REORGANIZE with a FILLFACTOR setting. These two do not go
together. You might want to file a bug report at
http://connect.microsoft.com/site/s....aspx?SiteID=68
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"sqldba" <sqldba@comcast.net> wrote in message
news:1163003565.772771.306170@m73g2000cwd.googlegroups.com...
> Seems odd to me that I can't find anything on this. SQLServer 2005 Dev
> running on Windows 2003 EE. Following this path from Management Studio
> click databases (select user db) > Tables > Indexes > Right click Index
> and select Properties. Select Fragmentation then click Reorganize index
> at the bottom of the window. I get the following error: "'fillfactor is
> not a recognized ALTER INDEX REORGANIZE option. (Microsoft SQL Server,
> Error: 155)"
>
> This is nothing more than a non-clustered index.
>
> Scripting it out it shows:
> USE [UserDB]
> GO
> ALTER INDEX & #91;ncx_table1_Col1]
ON [dbo].[table1] REORGANIZE WITH (
> FILLFACTOR = 90, LOB_COMPACTION = ON )
> GO
>
| |
|
|
|
|
|
|
|
|
|
|
|