Creating user temporary databases

Create multiple temporary databases using the temporary database keyword in the create database syntax:

create temporary database temporary_database_name on device_name=size log on device_name=size

For example, to create a user temporary database named tempdb_1 on the tempdb_device, enter:

create temporary database tempdb_1 on tempdb_device = 3 
log on log_device = 1