Doesn't suggest until I have typed entire object name

CodantiMCodantiM Posts: 245
edited September 14, 2010 6:34AM in SQL Prompt Previous Versions
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>

Comments

  • 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: [email protected]
  • 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.)
  • 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: [email protected]
Sign In or Register to comment.