Options
sql prompt 3.9.0.43 tables not showing
wsoranno
Posts: 65
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.
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
wsoranno@winona.edu
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
wsoranno@winona.edu
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
Comments
If I move up the script to line 200 or prior, then prompt works the way it is supposed too. At line 201 problems.
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
wsoranno@winona.edu
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92