SQL Server Prompt "column prefix tempdb. Invalid: Table name not Specified" problem solution _mssql

When querying vouchers and approving vouchers, "column prefix tempdb. Invalid: No table name specified" error prompt, how to solve?

Reason: Because SQL2000 cannot recognize special characters such as "-", "," and "Chinese" in the computer name, only English letters and numbers can be used.

Resolution: Right key to My Computer "properties" in "Computer name" click Modify, Change to pure English (preferably within 8 digits), remember that the computer name can not bring ",-" and other characters. can be solved.

After this problem is changed, then there are problems with the following: Ufida System Management When registered users "can not establish with the application server [POWERPC] point to the data server connection, can not log in, please select a different server." Description of Error: ( -2147467259) [Dbnetlib][connectionopen (Connect ()).] SQL Server does not exist or is denied access. " of errors. Later found that these errors as long as the server name in Ufida to the current computer name can be.