I am creating multiple indexes on a table in SQL Server. The script is still executing but all the required indexes are showing as objects in Object Explorer. Do the objects get created before the index creation has been completed or once the index has been created succesfully?
migrated from stackoverflow.com Oct 5 at 16:44
This question came from our site for professional and enthusiast programmers.
closed as unclear what you're asking by Kin, Paul White, Mat, Mark Storey-Smith, Jon Seigel Oct 6 at 14:26
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking.If this question can be reworded to fit the rules in the help center, please edit the question.
When you're restoring a database, it appears in the database list in Object Explorer before it's finished restoring, so it could conceivably be the same for indices.
If it's an indication of progress you're after, then placing a PRINT statement before your CREATE INDEX statement, and putting them all in different batches with the GO keyword will cause messages to be printed to the Messages tab in SSMS as your indices are created.