>Does anybody know if it is possible to create indexes on TABLE variables?
>
>(Using SQL Server 2000)
>
>If so, can it be done with a simple CREATE INDEX statement or am I limited to the constraints available when declaring the variable?
>

Hi Ben,

You cannot create additional indexes with CREATE INDEX statement on TABLE variables. You may consider temporary table as replcement.