Red Gate forums :: View topic - Doesn't suggest until I have typed entire object name
Return to www.red-gate.com RSS Feed Available

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

Doesn't suggest until I have typed entire object name

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
CodantiM



Joined: 29 Jun 2007
Posts: 182

PostPosted: Fri Sep 03, 2010 11:38 pm    Post subject: Doesn't suggest until I have typed entire object name Reply with quote

I have found that in some case SQL Prompt 4 (v 4.0.4.21) doesn't give me a suggestion until I type the entire object name, which seems a little late.

* To replicate create an SP:
Code:
USE master;
go

CREATE PROCEDURE dbo.sp_test AS
   SELECT 'Test procedure';
GO


* Refresh the suggestions

* Try to get the suggestion
Code:
EXEC sp<cursor>


At this point I don't get the suggestion for any of the objects that start with sp in the master DB. However once I type the whole name I get a suggestion:
Code:
EXEC sp_test<cursor>


But if I qualify it with the schema I am back to no suggestions:

Code:
EXEC dbo.sp_test<cursor>
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Tue Sep 07, 2010 10:31 am    Post subject: Reply with quote

Looks like your have turned off to show system objects in suggestion box.

Can you kindly turn it on and see if that makes any difference?

SQL Prompt 4--> Options --> Suggestions --> Types of suggestion --> and select 'List system objects' and it will start suggesting the objects.

Kindly let me know if this works for you.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
CodantiM



Joined: 29 Jun 2007
Posts: 182

PostPosted: Tue Sep 07, 2010 5:58 pm    Post subject: Reply with quote

Yes, I had List system objects turned off, but technically a user created SP isn't a 'system object'. (SSMS doesn't list it in the 'System Stored Procedures' folder.)
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Tue Sep 14, 2010 11:34 am    Post subject: Reply with quote

As 'MASTER' being a System database SQL prompt treats all the objects in/added to it as System Objects and hence the behaviour.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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