Home > Archive > SQL Anywhere database > May 2005 > change location of TempFileName









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author change location of TempFileName
david knox

2005-05-24, 8:23 pm

Hi,

Does anyone know how to change the TempFileName property on an existing
database?

ASA 9.0.2
windows 2000

thanks

david knox

2005-05-27, 3:23 am

Didn't find anything in the 9 documentation about this but tried a
guess that it was to do with the windows environment...

TempFileName path depends on the TMP user environment variable (on
windows 2000).
To change this for an existing database, shutdown the database, change
TMP and then restart.

select db_property('TempFil
eName')

to check the value before and after.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com