Assigned Temporary Database Inside an Application

In a clustered environment, the default temporary database assigned to a session is a local, temporary, instance-specific database. It is not the system tempdb (with a dbid of 2). After upgrading from a nonclustered environment, you may need to modify applications that previously used the system tempdb (with a dbid of 2) as the default temporary database in their actions, so that these actions are now applied to the assigned local temporary database in the Cluster Edition.

For example, in a nonclustered environment, an application truncates the log of the default temporary database when you execute:

dump tran tempdb with truncate_only

In the Cluster Edition, modify the application to truncate the log of the default temporary database:

declare @tempdbname varchar(30)
select @tempdbname = db_name(@@tempdbid)
dump tran @tempdbname with truncate_only