Database Objects Not Showing In SQL Prompt 5

woodrowbartlettwoodrowbartlett Posts: 3
edited March 8, 2012 9:13AM in SQL Prompt Previous Versions
Hello all,

I apologize if this is a duplicate thread, I could not find this topic anywhere else.

I have recently (today) installed SQL Prompt 5 as part of the SQL Developer Package and I cannot get Prompt to suggest any of my database objects.

Example:

SELECT * FROM Att

and I get nothing in the suggestions, even though there is a table named Attendance in this particular database.

Have I set something up incorrectly?
· Share on Twitter

Comments

  • woodrowbartlettwoodrowbartlett Posts: 3
    After further testing (I had to uninstall and reinstall to get this error) it says that SQL Prompt is timing out when trying to retrieve information from Master.
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    SQL Prompt is going to need a little access to master, at least to query the list of databases. If master is not responding, I'd be surprised if you weren't having serious problem with the server outside of SQL Prompt.

    Have you got any information from a SQL Profiler trace to show what query SQL Prompt was trying to run?
    · Share on Twitter
Sign In or Register to comment.