patternsqlMinor
Unknown _TransactionIndex table in Azure SQL Database
Viewed 0 times
unknownsql_transactionindexdatabaseazuretable
Problem
Just noticed today that there is a random table in my Azure SQL Database that is named "_TransactionIndex_{guid}"
It has 1 column, Id, that contains 8 GUIDs.
Couldn't find any information about this table - what is it? Does it mean that I have an issue with transactions within my application?
It has 1 column, Id, that contains 8 GUIDs.
Couldn't find any information about this table - what is it? Does it mean that I have an issue with transactions within my application?
Solution
It's an internal table that is used during the import of a
bacpac. If all is well it should be gone when the import is done. If it remains in the database the import wasn't completed successfully.Context
StackExchange Database Administrators Q#60385, answer score: 6
Revisions (0)
No revisions yet.