Help with T-SQL Statement??

[ostinoh]

Hello - I'm in the process of using a script that will help with re-indexes. I keep getting the following errors. Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '('. Msg 156, Level 15, State 1, Line 10 Incorrect syntax near the keyword 'ELSE'. My database name is Backdrop and the table is dbo.PJTRAN and the index is pjtran0. Here is the script if someone can help me understand why I keep getting those errors. IF EXISTS (SELECT [object_id],[index_id],[avg_fragmentation_in_percent] FROM sys.dm_db_index_physical_stats (DB_ID(N'Backdrop'), OBJECT_ID(N'PJTRAN.PJTRAN0'), NULL, NULL , 'DETAILED') WHERE [avg_fragmentation_in_percent] < 30) BEGIN ALTER INDEX ALL ON PJTRAN REORGANIZE END ELSE ALTER INDEX ALL ON PJTRAN REBUILD Thank you..

[Don Burton]

Have you executed the script in Query Analyzer?

[ostinoh]

This is for a SQL 2005 database. I'm using SSMS.

[Mycroft Holmes]

If what exists, the structure does not make sense, you are selecting a row and then ask if something exists. Change the script to:

DECLARE
@Count INT

SELECT @Count = COUNT(*)
FROM sys.dm_db_index_physical_stats
(DB_ID(N'Backdrop'), OBJECT_ID(N'DBO.table'), NULL, NULL , 'DETAILED')
WHERE [avg_fragmentation_in_percent] < 30

IF @Count > 0

Never underestimate the power of human stupidity RAH