Doesn't suggest until I have typed entire object name

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Doesn't suggest until I have typed entire object name

Postby CodantiM » Fri Sep 03, 2010 11:38 pm

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: Select all
USE master;
go

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


* Refresh the suggestions

* Try to get the suggestion
Code: Select all
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: Select all
EXEC sp_test<cursor>


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

Code: Select all
EXEC dbo.sp_test<cursor>
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Anu Deshpande » Tue Sep 07, 2010 10:31 am

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby CodantiM » Tue Sep 07, 2010 5:58 pm

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.)
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Anu Deshpande » Tue Sep 14, 2010 11:34 am

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests