Posts
Sort by recent activity
Candidate list need to fit within desktop view
When typing a query in Query Analyzer and hitting CTRL+SPACE to bring up the candidate list, the Candidate list is not within the dekstop view ie scroll bars are not visible because they are outsid...
Mixed Case
Typed in the following in :
select * from [dbo].[Policies] AS p
The select and from keywords were typed in lowercase and remain that way, however the AS is in Caps.
emails4me
SQL Prompt 3 crashes with Query Analyzer (day 3)
I usually don't restart by support PC unless I have to. My PC has been running SQL Prompt 3 since I first installed it on Monday. I had MSMMS open last night and SQL Prompt 3 running. Came in this...
Suggested Joins not displayed ?
In SQL Prompt 2, there was a list of possible joins between tables. Is there a way of getting a list in SQL Prompt 3.
example:
select top 1 * from
[dbo].[Quotes] AS q join [dbo].[QuoteItem] AS qi o...
Stored Proc Parameters not displayed in Candidate List
I like the way this worked in SQL Prompt 2 but for some reason (not sure if I'm doing something wrong) the list of parameters is not listed in the candidate list ?!
emails4me
No Intellisense with 2 SQL Query Analyzer Open
I have 2 SQL Query Analyzer Windows Open. When I started them the SQL Prompt Tray appeared for both of them. 1 windows has intellisense and the other doesn't. Both point to a different SQL Server 2...
Unhandled Exception Error with non TT fonts
I start up Query Analyzer via SQL Server Enterprise Manager : Tools/SQL Analyser. The SQL Prompt windows appears to near the task bar and then the follow error occurs :
Microsoft .NET Framework
Unh...
SQL Promp3 sometimes doesn't work with MS Query Analyzer
Sometimes when switching between the MS SQL Server Management Studio and MS Query Analzer, SQL Prompt no longer works with MS Query Analyzer. I quit SQL Prompt 3 and restarted it. Same result; wor...
Intellisence on Commented Code
SQL Prompt gives me intellisence on Commented code:
Type in -- NEW PROC CREATED
holding down the shift key while type something in caps and you get the SQL Prompt intellisense? is there a way to te...
DateTime Column confusion
I have a policies table with the following fields:
PolicyID
Datetime
When I type in
select * from policies as P order by P.
after I type in P. I get a list of column names I select the DateTime col...