>>>I am using .idx indexes for sorting on some tables and when I try to execute command BEGIN TRANSACTION I get error because of using those .idx indexes.
>>>
>>>Can someone tell me what do?
>>
>>You could just read help for
BEGIN TRANSACTION:
>>"All IDX index files (non-structural, or non-CDX based, indexes) must be closed during transactions. Only structural indexes are supported within transactions".
>
>Can it be still done without closing indexes?
I guess not.
If it's not broken, fix it until it is.
My Blog