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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migration rejected from stackoverflow.com Oct 6 '13 at 14:26
This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.
closed as unclear what you're asking by Kin, Paul White♦, Mat, Mark Storey-Smith, Jon Seigel Oct 6 '13 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. See the How to Ask page for help clarifying this question.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.