It you are running out of diskspace because of large temp files on your sql box, you can change the location of the tempdb where you have more space select * from dbo.sysdatabases
USE master
GO
ALTER DATABASE TempDB MODIFY FILE(NAME = tempdev, FILENAME = 'D:\DB\tempdb.mdf')GOALTER DATABASE TempDB MODIFY FILE(NAME = templog, FILENAME = 'D:\DB\tempdb.ldf')
FILENAME = is the new location- You will have to restart SQL to take effect.
GO
Enjoy, Mark
Be the first to rate this post
- Currently 0/5 Stars.
- 1
- 2
- 3
- 4
- 5