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

One particular database frequently doesn't respond

dcolbertdcolbert Posts: 15
edited March 18, 2011 9:48AM in SQL Prompt Previous Versions
I have weveral databases on a particular server. For some reason, SQL Prompt will frequently lose the ability to resolve the "main hub" database.

It will resolve that there is a table and even show the script of the table, but when I try to qualify object names it will fail. It states that SQL Prompt can't find the table object in the database. It will also underline the query's table reference in red stating that it can find the table. But when I CTRL-[Space], it will still show the table and its definition summary.

Sometimes when that happens, I can disable-and-renable SQL Prompt and it will work. Other times that won't work.

Any help you can provide would be greatly appreciated!

Thanks in advance.

Dan
Sign In or Register to comment.