I have a 9GB drive on an independent SCSI channel that I would like to relocate tempdb to in SQLServer 2000 for performance reasons. Everything I have read leads me to believe this isn't possible. Say it ain't so!

Any ideas?

Thanks,

Mark