Red Gate forums :: View topic - ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
bstrautin



Joined: 19 Sep 2011
Posts: 2

PostPosted: Wed Feb 26, 2014 5:48 pm    Post subject: ALTER after GO suppresses FUNCTION, PROCEDURE, VIEW, TRIGGER Reply with quote

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:

-- anything
GO
ALTER


But this does not:
Code:
GO
ALTER


And this does not work either:
Code:


select top 10 * from sys.tables GO
ALTER


The popup from both cases should be the same.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Thu Feb 27, 2014 6:40 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group