What are the challenges you face when working across database platforms? Take the survey

Supposed to recognize views and user-defined funcs?

BrianFinkelBrianFinkel Posts: 33
edited June 15, 2007 7:29AM in SQL Prompt Previous Versions
Hi, I'm trying out SQL Prompt 3, and it seems improved over SP2 (especially the UI), but I have some questions:

1 - Is it supposed to know about views? I get no suggestions for views or columns in views.

2 - Is it supposed to know about User-Defined Funcs that return a table? Does not work for me.

3 - Supposed to know about sproc/udf input params when calling? Also does not work.

If these items are not yet supported, I would suggest that they are pretty important areas of functionality, at least for me. Any estimate on when they will be implemented?

Using Sql Prompt 3.7 with SQL Server 2000, Query Analyzer, and 2005 Mgmt Studio.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Brian,

    I think Prompt should do all of these things. I'm curious to know wht it wouldn't work for you. Perhaps you're in the wrong database context? Putting USE <dbname> in the query window might help.
Sign In or Register to comment.