• 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.


    I am really sorry for my poor gramma. And I hope that value of my answers will outweigh the harm for your eyes.
    Blog: http://somewheresomehow.ru[/url]
    Twitter: @SomewereSomehow