The information on multiple tempdbs was inadvertently included in the Performance and Tuning Guide. This information is being moved to the System Administration Guide in 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.
Copyright © 2004. Sybase Inc. All rights reserved. |