ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER

Postby bstrautin » Wed Feb 26, 2014 5:48 pm

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:
Code: Select all
-- anything
GO
ALTER


But this does not:
Code: Select all
GO
ALTER


And this does not work either:
Code: Select all

select top 10 * from sys.tables GO
ALTER


The popup from both cases should be the same.
bstrautin
 
Posts: 2
Joined: Mon Sep 19, 2011 9:47 pm

Postby Manfred.Castro » Thu Feb 27, 2014 6:40 pm

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
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests