Hi All,
I can't change the location of tempdb.
I have SQLServer 6.5/Sp5a with NT 4.0 /Sp4.
Originally TempDB was on the disk.
I Executed the following command to take TempDB in To RAM.
sp_configure "tempdb in ram", 2
go
reconfigure
go
I Restarted SQL Server
it was ok.
Tempdb was in RAM
After that I executed Diskeeper Lite on the same disk for disk defragmentation.

ThereAfter I wanted to change Tempdb Location again and to place it on Disk
sp_configure "tempdb in ram", 0
go
reconfigure
go
I Restarted SQL Server
Executed sp_configure

name minimum maximum config_value run_value
.
tempdb in ram (MB) 0 2044 0 2
.

Although the config_value was 0 , the TempDB was not removed from RAM.

The Tempdb Database using the TEMP_DB device.
I saw that TEMP_DB device uses in RAM (with this script select * from sysdevices)

low high status cntrltype name phyname
.
16777216 16778239 2050 0 TEMP_DB IN_RAM
.

When I want to expand The tempdb database, I got this error message.

"Error 5016.[SQL Server] incorrect database or device name(s)"

What can I do?

Thanks in advance.