--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:

>
> Arda wrote:
> >
> > Thank you Dmitry, but when I set the transaction option to WAIT and
> > try, it never starts creating the index and waits for ever. There are
> > about 150 users on the site. Can this be because one of the clients
> > crashed when it was in the middle of a transaction?
>
> I don't think so. Most probably users just don't have any pause in

their

> table modifications. If so, a database shutdown would be your only

choice.

>
>
> Dmitry
>

Hi Dmitry, I've rebooted the server and tried and it was no use. I'll
try to create the index at night when there's no one else
working(except me). Thanks.