USE master
go
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'Path empdb.mdf')
go
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'Path emplog.ldf')
go
另外清除TEMPDB中数据的最好的办法是重启SQL服务器、
USE master
go
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'Path empdb.mdf')
go
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'Path emplog.ldf')
go
另外清除TEMPDB中数据的最好的办法是重启SQL服务器、