December 8, 2010 at 12:17 pm
When I run a TSQL query at my desktop machine against a database residing on a remote server the query process produces a *.tmp file on my local machine in my c:\documents and settings\myname\local settings\temp folder which grows in direct relation to the time the query runs until the disk partition runs out of space.
I've moved the local MASTER and TEMP DB to another (D:\) larger drive with no trouble, but when I restart the services and re-connect and re-run the query the TMP file still appears on the above mentioned folder on drive C. What do I need to do to get this tmp file to appear on my D drive where there is plenty of space for it?
Thanks
December 13, 2010 at 8:58 am
right click "my computer" select properties.
go to Advanced tab select "Environment Variables"
In "User variable for yourlogin" click edit on TEMP and change to D drive location.
restart SSMS.
December 13, 2010 at 10:37 am
AlexSQLForums (12/13/2010)
right click "my computer" select properties.go to Advanced tab select "Environment Variables"
In "User variable for yourlogin" click edit on TEMP and change to D drive location.
restart SSMS.
Thanks for the reply. I managed to figure this out.. and did what you suggest here, except that the change I made was to the line "TMP", not "TEMP".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply