DMV columns appearing in Prompts

Dave PendletonDave Pendleton Posts: 82 Bronze 3
edited September 11, 2009 11:15AM in SQL Prompt Previous Versions
Often while typing, I am prompted with columns from various Dynamic Management Views.

For example, when I type:
IF ISNULL(OBJECT_ID

I am prompted with the object_id column from sys.dm_qn_subscriptions.

How do I disable this?

Comments

  • Thanks for your post.

    From your problem specification if I am not getting you wrong I feel following settings should help:

    SQL Prompt 4 --> Options --> Suggestions --> Type of suggestion --> deselect option List system objects

    If this doesn't resolve can you kindly let us know the steps to reproduce the problem?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • I want system objects to be suggested, just not the columns.

    Has this behavior changed in this version?
Sign In or Register to comment.