CREATE TABLE #IndexFrag(

database_id int,

object_ID int,

index_id int,

name varchar(max),

page_count int,

avg_fragmentation_In_Percent real )

Change your NAME column to varchar(max) and I think your code will work.

Kurt