• Not at all. SQL's quite capable of handling index creation while the DB's in use.

    Since you're on SQL 2005, you can create the index either online or offline. Offline is the behaviour from 2000, the table is readonly while the index is been created.

    Online, the table can be read and written while the index is been created and after creation, SQL merges in any changes that happened during the build.

    Either way, you don't have to force locks or transactions or anything like that. The engine handles all that internally

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass