One particular database frequently doesn't respond
dcolbert
Posts: 15
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
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
