Doesn't suggest until I have typed entire object name

MikeyC

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>

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.

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.)

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.