Brian Donahue wrote:
Thank you for your post. I have logged this down as a bug in SQL Prompt, to be fixed in a future release. Even in AdventureWorks or northwind, regardless of whether SQL Prompt is used in Query Analyzer or Management Studio, stored procedures and views never show up in the candidate list. Functions and types seem to be available, so it's confusing as to whether this is meant to work, or it works partially 'by accident'. Either way, this support should get fixed or taken out.
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal