You can bind:
A user login or application to multiple local user temporary databases, but only to one database per instance.
For example, you can bind “sa” to local_tempdb1 on “ase1” and local_tempdb2 on “ase2”, but you cannot also bind “sa” to local_tempdb3 on “ase1”.
A user login or application to only one database group. Temporary database groups are visible from all instances.
For example, if you bind isql to the default group, you cannot also bind isql to another temporary database group.
A user login or application to individual temporary databases or a temporary database group, but not to both.
For example, if “sa” is bound to local_tempdb1 on “ase1”, it cannot also be bound to the default group.
