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?

migrated from stackoverflow.com Mar 7 '14 at 8:29

This question came from our site for professional and enthusiast programmers.

  • I don't know what the answer is but I have seen this table appear a few times in dbs I have imported from Bacpac files on Azure and each time the import has errored in some manner. – AlexC Sep 17 '14 at 21:40

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.