The information on multiple temdbs was inadvertently included in the Performance and Tuning Guide. This information should be in the System Administration Guide and will be moved there on the next update.
In prior versions only a user with the “sa” role could be bound to a tempdb.
As of this version of Adaptive Server, any user can also be bound to an application at the time of login. For example:
If there is a binding for login “user1” and for application isql, when "user1" logs in with application isql the “user1” binding determines the tempdb assigned to the session, not the isql binding.
