DMV columns appearing in Prompts

Dave Pendleton

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?

Anu D

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?

Dave Pendleton

I want system objects to be suggested, just not the columns.

Has this behavior changed in this version?