Hi

For the ALTER DATABASE TEMPDB ... command to change the location and size of TEMPDB requires SQL Server Restart.

Shrinking the Tempdb using DBCC commands requires that TEMPDB doesn't have any active connections. This needs SQL Server to be started in Singe User mode.

http://support.microsoft.com/kb/307487

Thank You,

Best Regards,

SQLBuddy