Re: Locking Info

This probably is expected behaviour.

You may be aware that from ASE 12.5.0.3, multiple temporary databases
are available to deal with such concurrency problems.

If upgrading is not an option, you could try to distribute the creation
of your own temporary tables in explicitly created databases for this
purpose ... Then your temp tables cannot be of the form #table1. They
will need to be of the form user_tempdb1..table1.

This surely is an awkward solution. This will not benefit concurrency
problems related to internally generated temporary tables (such as
worktables generated for sorting).

Regards,
Ashish

.