Execute the following Microsoft SQL Server T-SQL database administration script in Management Studio Query Editor to demonstrate the setting of compatibility level of tempdb to SQL Server 2000 (80) and back to SQL Server 2005 (90). SQL Server 2008 is 100.

use tempdb
go

sp_dbcmptlevel tempdb, 80
go

sp_helpdb
go

sp_dbcmptlevel tempdb, 90
go

sp_helpdb
go

Related article:

SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility