I open a new query in ssms and create a global temp table. I then open a new query window in ssms and write sql to insert data in the fields. But in the new query window intellisense does not recognize the temporary table. The sql works fine and the data
is inserted into the temp table and I can work with the temp table but without intellisense. I can return to the original query window where the table was created and intellisense work fine. I have tried refreshing intellisense, it doesn't work. Any suggestion
will be appreciated.
