Is anyone familiar with a way to reset the identity value on a table variable...

the DBCC command doesnt seem to work on a table variable...

I try this:
dbcc checkident ('@block, RESEED, 1)

I get this msg, rightfully so..

Could not find a table or object named '@block'. Check sysobjects.

My block table has an identity column called "blockid". Is there anyway I can update this column after the inserts have been done? Or does anyone know of any other way I can use the identity capability on a table variable?

Thanks much