Shulou(Shulou.com)05/31 Report--

This article mainly introduces "SqlServer tips" column prefix tempdb. Invalid: table name "how to deal with", in daily operation, I believe many people in SqlServer tips "column prefix tempdb. Invalid: table name not specified" how to deal with the problem there are doubts, Xiaobian consulted all kinds of information, sorted out simple and easy to use operation methods, hope to answer "SqlServer tips" column prefix tempdb. Invalid: table name "how to deal with" doubts helpful! Next, please follow the small series to learn together!

Reason: SQL2000 cannot recognize special characters such as "-","," and Chinese characters in computer names. Only English letters and numbers can be used.

Solution: Right click on "Computer Name" in "Properties" of my computer and click Modify to change it to pure English (preferably within 8 digits). Remember that the computer name cannot have characters such as "and-." That'll fix it.

After this problem is corrected, there are problems that follow: Yonyou system management registered users appear "cannot establish a connection with the application server [POWERPC] pointed to the data server, can not log in, please select another server. Error Description: (-2147467259)[DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied. "The mistake. Later found that these errors as long as the UF service server name changed to the current computer name can be.

At this point, about the "SqlServer prompt" column prefix tempdb. invalid: did not specify the table name "how to deal with" the study is over, I hope to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.