the below sql statement was executed in the 2008r2 server under SA credentials
SELECT * INTO TEST1 FROM SQL2KServer.DB1.dbo.Table1
the object was creates successfully and even I can query the table TEST1 in 2008R2 server and see all the records
My question is; when i type the table name in the statement it gets underlined with red color indicating "Invalid object name 'TEST1'". (also in the update and delete statement too). So to get rid of this, I closed the connection and then reconnected the query window, still same. So thought of restarting the SQL SERVER service and did and then checked, still same, and finally I had to restart my PC and then when I checked, now the object was showing as normally like other objects. Really not sure of the cause, but want to know is there any fix/work-around for this or restarting the server is the option?
SQL 2000 Version:
Microsoft SQL Server 2000 - 8.00.2065 (Intel X86) Jan 11 2012 18:00:51 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
SQL 2008 R2 Version:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (Intel X86) Apr 22 2011 11:57:00 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.