Activity overview
Latest activity by justevaluating
Thanks Bart!
If this works as great as the rest of it does, I'll be purchasing between 5 - 10 licenses. How does this work with versions? If we purchase licenses now, are we purchasing licenses for 3.1? Will we have to pay to upgrade to 3.5 when it is finally released?
Thanks. / comments
Thanks Bart!
If this works as great as the rest of it does, I'll be purchasing between 5 - 10 licenses. How does this work with versions? If we purchase licenses now, are we purchasing licenses for...
Bart Read wrote:
OK, something to check now. In your editor please click on the SQL Prompt > Options menu item. Then go to the "Listed Candidates" tab and then make sure you're on the "Cross-Database Support" screen. Then make sure "Enable cross-database and linked server support" is enabled.
Thanks,
Bart
Ah! I don't have a "Cross-Database Support" screen or "Enable cross-database and linked server support" checkbox. Could this be a version issue or a 14-day trial thing? I'm currently running the 14-day trial (v. 3.1.0.40) / comments
Bart Read wrote:
OK, something to check now. In your editor please click on the SQL Prompt > Options menu item. Then go to the "Listed Candidates" tab and then make sure you're on the "Cross-Dat...
Bart Read wrote:
OK thanks. Have you tried forcing the popup with CTRL+SPACE after "[Production]."? What does it show?
@identity". Nothing from the Production db.
Also tried "[Production].dbo." (CTRL+SPACE). Same thing.
This product is *exactly* what our development group needs, but we do need to run queries across dbs. We actually have 3 separate dbs (on the same server) that we need to hit on a regular basis, so the ability to get intellisense working would be great.
Thanks for your help. I hope I am just overlooking something here. / comments
Bart Read wrote:
OK thanks. Have you tried forcing the popup with CTRL+SPACE after "[Production]."? What does it show?
@identity". Nothing from the Production db.
Also tried "[Production]....
The popup appears, but it is empty.
(restarted SQL Prompt)
if I launch Query Analyzer I'm by default in 'master'.
If I then attempt to select from my db called "production", I can't.
select *
from [production].
- no intellisense / comments
The popup appears, but it is empty.
(restarted SQL Prompt)
if I launch Query Analyzer I'm by default in 'master'.
If I then attempt to select from my db called "production", I can't.
select *
from ...
doesn't work across databases?
SQL Server 2000
If I'm in query analyzer and the selected db is db1, I can't qualify the table as [db2].tablename and get the intellisense?
Attempting to write a query that does the following...
se...