Home > IT Answers > Storage > Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
SQL Server Ask the Experts
2,585 pts.
 Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Data availability, Enterprise Manager, Indexes, SQL Server 2000, SQL Server Enterprise Manager
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

Software/Hardware used:
ASKED: May 14, 2008  3:24 AM
UPDATED: May 14, 2008  1:56 PM
RELATED QUESTIONS
Answer Wiki:
No, the table will be locked while the index creation command is running.
Last Wiki Answer Submitted:  May 14, 2008  7:39 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _