When I try to create indexes on a temporary table in SQL Server when using the
SNAPSHOT transaction isolation, I get this error:
Transaction failed because this DDL statement is not allowed inside a snapshot isolation transaction. Since metadata is not versioned, a metadata change can lead to inconsistency if mixed within snapshot isolation.
Why is it not allowed to create indexes on temporary tables in SQL Server when using snapshots?
I don't understand this, if I'm allowed to create temporary tables, why am I not allowed to add indexes to them?
Cache file /home/queryxchang/public_html/apps/frontend/config/../cache/-q-7-206804-why-is-it-not-possible-to-create-indexes-on-temp-tables-in-snapshot-isolation- could not be written