Topics

in MS SQL #tempfile

"el_kapitan88" <kapitan88@...>
 

Hi Magicians,

Just wanna ask if anyone encountered this problem: "Cannot create
index on "#tempfile" because this table does not exist in database"

The file can be accessed in the server via {Ctrl-G), but when deployed
on workstation, each time this temporary file is being accessed, the
message above is displayed and Magic crashes.

Using Magic V9 SP7 and MSSQL 2000 SP3 as the database on a PC with
Windows 2003 Server.

The files accessed has a unique key, and setup as local temp file only
{dataname = #filename} pointed in SQL_SERVER.

Please help. tnx.