ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER

bstrautin

If a GO statement is not preceded by a newline, e.g. is first text in a query window, the autocomplete suggestions for a subsequent ALTER will exclude FUNCTION, PROC, PROCEDURE, VIEW, and TRIGGER, even though they should be included.

For example, this works as expected:

-- anything
GO
ALTER

But this does not:

GO
ALTER

And this does not work either:

select top 10 * from sys.tables GO
ALTER

The popup from both cases should be the same.

Manfred.Castro

Hi Benjamin,

I was able to reproduce the reported behavior and have logged this issue under the internal reference number of SP-5038.

Unfortunately I am unable to provide a definitive timeline for when this might be fixed.

Sorry for any inconvenience this may have caused.

Sincerely,
Manfred