I was getting this error about '...tempdb ... system segment is full...dump transaction..'
so i made a new device calling it tempdata and assigned Tempdb to it. I did not pay attention
to the fact that it was going on the C drive where space is limited rather than the D drive where
everything else is. SQL Server will not let me drop this device because it says Tempdb is a system database
Right now i have two devices (tempdev and tempdata) both for Tempdb. I need only one, tempdev, and i
need to drop tempdata. How can i recover that space on the C drive without reinstalling SQL Server?