sql prompt 3.9.0.43 tables not showing

wsorannowsoranno Posts: 65
edited August 5, 2008 5:54PM in SQL Prompt Previous Versions
When I try to do a join to a table across databases , I only get a list of columns from the other tables already joined. I have cleared the cache, I have refresh the cache to no avail.

The script is for an alter procedure. The total number of line in the script is 390. The join I am trying is at line 205. I have the preformance set to 500 lines. I have tried "Search entire batch/GO block..." with the same results.

If I open an "New Query" and build a select * from dbname.dbo. then I get the correct list of tables.

I upgraded to 3.9 yesterday.
Thanks
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
[email protected]

"Quality, like Success, is a Journey, not a Destination" - William Soranno '92

Comments

  • additional info:

    If I move up the script to line 200 or prior, then prompt works the way it is supposed too. At line 201 problems.
    Thanks
    Bill Soranno
    MCP, MCTS, MCITP DBA
    Database Administrator
    Winona State University
    Maxwell 143
    [email protected]

    "Quality, like Success, is a Journey, not a Destination" - William Soranno '92
Sign In or Register to comment.