Options

DMV columns appearing in Prompts

Dave PendletonDave Pendleton Posts: 104 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?
· Share on Twitter

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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: support@red-gate.com
    · Share on Twitter
  • Options
    Dave PendletonDave Pendleton Posts: 104 Bronze 3
    I want system objects to be suggested, just not the columns.

    Has this behavior changed in this version?
    · Share on Twitter
Sign In or Register to comment.