When coding ALTER TABLE xxx DISABLE TRIGGER, list just that table's triggers, not every one on every table
The suggestions list after the TRIGGER is full of triggers. SQL Prompt, having been given the schema and table should narrow that list to only those present on the table to be ALTERed.
I would categorize this as a bug, rather than a suggestion...
5
votes
Stephen
shared this idea
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Daniel White
commented
There are lots of places where SQL Prompt shows too much information. Try putting the cursor between the SELECT and FROM in SELECT FROM sys.databases and pressing control-space; it should only show my columns in sys.databases, but it looks like it shows every column in every table and view.