Bind To Temporary Database

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action builds and submits a sp_tempdb bind system procedure call. It lets you bind a login to a temporary database.

Platform Availability

To Bind a Login to a Temporary Database

  1. Initiate a Bind To Temporary Database action against one or more logins. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Bind To Temporary Database wizard:
Step Settings and tasks

Action Options

Select the target temporary database from the Bind To Temporary Database dropdown.


Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies.


Displays the DDL that will execute the object action. For details, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.