Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager? (Q/A)

Posted by NosaLee in SQL Server on 14-06-2012. Tags: , , ,

Q 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?

Re by Mrdenny

No, the table will be locked while the index creation command is running.

Original Address: http://itknowledgeexchange.techtarget.com/itanswers/is-the-data-in-a-sql-server-2000-table-still-available-for-external-applications-during-editing-or-adding-indexes-via-the-enterprise-manager/

(0) Comments
Read More

Post a comment