Question

  Asked: May 14 2008   3:24 AM GMT
  Asked by: SQL Server Ask the Experts


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 2000, Enterprise Manager, Indexes, Data availability, 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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



No, the table will be locked while the index creation command is running.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server, Database and Storage.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register