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

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