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.