When SQL Server 7 was installed, the original tempdb was on the C: drive. Later, someone defined another tempdb file on the D: drive (a faster drive). The one on C: is primary (I suppose that is what the key symbol means in Enterpise Manager / Right Click Database / Properties).
How do I delete the C: one and make the D: one primary? I see a KB article on moving tempdb, but don't know how to safely delete one of the files.
Thanks
Jay
KB Article:
http://support.microsoft.com/support/kb/articles/q224/0/71.asp?LN=EN-US&SD=gn&FR=0&qry=Moving%20TEMPDB&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=SQL