Hi,

I had similar problems with this before.

I want to add an index on a table and I get this error:

lock conflict on no wait transaction
unsuccessful metadata update
object <TABLE> is in use

The table in this case is one of the main tables, so it's always in use. There are more then one application using this database and this table, including web clients, so I don't want to reboot, take the database offline or kill all the processes on the table.

Is there anyway to bypass this "lock conflict" and force the database to create that index?

Thank you