Activity overview
Latest activity by BrianFinkel
Here's something else I just noticed while using Example 2 as a workaround for the problem in Example 1...
In Example 2 you get no suggestions from Sql Prompt when referencing Table1 in the main query.
So, it appears that in Example 1, there are no suggestions for the subquery, while in Example 2, there are none for the main query. / comments
Here's something else I just noticed while using Example 2 as a workaround for the problem in Example 1...
In Example 2 you get no suggestions from Sql Prompt when referencing Table1 in the main qu...
Bug - No Column Candidates in Subquery
This is a reproducible problem for me:
SELECT (
SELECT TOP 1 Col1
FROM Table2 AS t2
WHERE t2.
) as val
FROM Table1 AS t1
In the query above, typing the '.' after WHERE t2 does not get any response...
Suggestion - Table/View Candidate Columns
When you type 'SELECT * FROM '...
...Sql Prompt displays a list of tables and/or views in the candidate list, and when you highlight one of those tables or views, it shows the definition in another...
I spoke to Tanya on the phone yesterday and, during our conversation, she suggested switching databases, refreshing, switching back, and refreshing again, and that seemed to clear it up for the moment. I don't know why I didn't try that before -- perhaps I had some "troubleshooting fatigue."
I have not had quality dev time with it, though, so I can't really sign off just yet. But I'm optimistic. And I should have some time today.
This was the biggest problem I've had with the program, so my fingers are crossed. / comments
I spoke to Tanya on the phone yesterday and, during our conversation, she suggested switching databases, refreshing, switching back, and refreshing again, and that seemed to clear it up for the mom...
Just wondering what the status is on this and whether I need to do something special to make a real support incident out of it.
Thanks,
Brian / comments
Just wondering what the status is on this and whether I need to do something special to make a real support incident out of it.
Thanks,
Brian
INFORMATION_SCHEMA - Beyond Glitch!
So I installed SSMS 2005 and upgraded to Sql Prompt 3.7 as per your suggestions. Now the INFORMATION_SCHEMA views do not appear no matter what I try.
This thread has the original problem I encount...
10-4. Will give it a try. / comments
10-4. Will give it a try.
OK. Will try that when I have a chance.
Do you have any idea whether the SQL 2000 client tools (Query Analyzer, Profiler, Enterprise Mgr, etc.) can peacefully coexist on the same machine with SQL 2005 tools?
Thanks,
Brian / comments
OK. Will try that when I have a chance.
Do you have any idea whether the SQL 2000 client tools (Query Analyzer, Profiler, Enterprise Mgr, etc.) can peacefully coexist on the same machine with SQL ...
OK. Got the update from support. Will let you know after I have a chance to try it.
Is there any reason why 3.7 would be less stable than 3.6 or present other issues? Is there any potential tradeoff in upgrading? / comments
OK. Got the update from support. Will let you know after I have a chance to try it.
Is there any reason why 3.7 would be less stable than 3.6 or present other issues? Is there any potential trad...
Is checked, was checked.
And just to be clear, this issue is not currently a problem for me. It was a temporary, odd situation after install. / comments
Is checked, was checked.
And just to be clear, this issue is not currently a problem for me. It was a temporary, odd situation after install.