Binding to groups and tempdb

The sp_tempdb. . . 'bind'...’unbind’ system procedure allows you to bind, or unbind, an application or login to specific temporary database or tempdb group. After you create the binding, when the application or login connects to the server, Adaptive Server assigns the specified temporary database or temporary database group to which it is bound. Binding allows you to control the temporary database assignments for specific applications or logins.

This example binds the log in sa to the default group:

sp_tempdb 'bind', 'lg', 'sa', 'GR', 'default'

This example unbinds the login sa:

sp_tempdb 'unbind', 'lg', 'sa'

See Reference Manual: Procedures for the complete sp_tempdb syntax.