How can we help you today? How can we help you today?

Doesn't suggest until I have typed entire object name

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

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

* Refresh the suggestions

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

But if I qualify it with the schema I am back to no suggestions:
EXEC dbo.sp_test<cursor>
MikeyC
0

Comments

3 comments

Sort by
  • Anu D
    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.
    Anu D
    0
  • MikeyC
    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.)
    MikeyC
    0
  • Anu D
    As 'MASTER' being a System database SQL prompt treats all the objects in/added to it as System Objects and hence the behaviour.
    Anu D
    0

Add comment

Please sign in to leave a comment.