Thanks for all the suggestions. Unfortunately, I have already tried both of these variations with no luck. I really think there is something fundamentally wrong here.

I am actually testing...

Apologies Frank, this was an error on my part when I first added the script. I changed it and it still doesnt work.:ermm:

There is no error returned. I added a print statement to the cursor and the indexes and tables are all correct.

Just tried the rebuild statement on its own sometimes it...

Nope, still doesnt work. Im banging my head here.

Just seen your post sql_lock. Ill give it a try.

Thanks for the tip. However, I printed the string and there were no errors:

ALTER INDEX [TestIndex] ON [dbo].[TestTable] REBUILD

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,

ALLOW_ROW_LOCKS =...

Thanks for the suggestion but I only want to rebuild the indexes in one specific database. Is there any reason why my code wont work?