Home Forums SQL Server 2008 T-SQL (SS2K8) SELECT INTO SQL2K8 from SQL2K RE: SELECT INTO SQL2K8 from SQL2K

  • August 7, 2012 at 2:06 am

    #1522428

    SomewhereSomehow (8/7/2012)

    Be sure on what server and db do you execute "select ... into" query. Also specify schema like "select ... into dbo.MyTable...".

    After that, when you want to query created table - verify server, db, specify schema and everything should be ok.

    btw:

    to avoid underlining in SSMS after the new object is created - you may update local cache by pressing: CTRL+SHIFT+R. This has no relation to server.

    awesome, refreshing the local cache works. thank you. 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.