Doesn't suggest until I have typed entire object name

MikeyCMikeyC Posts: 249 Bronze 3
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>
· Share on Twitter

Comments

  • Anu DAnu D Posts: 876 Silver 3
    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
    · Share on Twitter
  • MikeyCMikeyC Posts: 249 Bronze 3
    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.)
    · Share on Twitter
  • Anu DAnu D Posts: 876 Silver 3
    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
    · Share on Twitter
Sign In or Register to comment.