Type in the following SQL:
select * from sys
and hit Ctrl+Space. Select 'syscacheobjects'. You will get:
select * from [sys].[syscacheobjects] AS s
Put the cursor at the end of 'syscacheobjects' and hit the backspace key until only 'sys' is show. Hit ctrl-space and select 'syscolumns' from the candidates list. You would expect:
select * from [sys].[syscolumns] AS s .
But instead get:
select * from [sys].[sys].[syscolumns] AS s] AS s
select * from sys
and hit Ctrl+Space. Select 'syscacheobjects'. You will get:
select * from [sys].[syscacheobjects] AS s
Put the cursor at the end of 'syscacheobjects' and hit the backspace key until only 'sys' is show. Hit ctrl-space and select 'syscolumns' from the candidates list. You would expect:
select * from [sys].[syscolumns] AS s .
But instead get:
select * from [sys].[sys].[syscolumns] AS s] AS s