Posts
Sort by recent activity
See lots of red lines?
Not sure what's going on here, but I see a lot of red lines when trying to write T-SQL Code in SSMS 2008. At one point, I would arrow up or down and the red lines would move around the screen as I ...
SQL Backup and SQL Compare?
Where would we get more information about using the two together? It almost sounds as if we could restore a table directly from backup without needing to restore the entire DB. Is that correct or...
[FR?] Columns in table take precedence over functions?
Another issue I run into often. We have a couple of tables that have "Is_Enabled" or "Is_Active" or similar as column names. When I start to type out to get down to that area, the "IS" operator j...
[FR] Ability to sort by physical column order?
I know I've requested this before, but was wondering if this is on the roadmap or something that will be released prior to SQL Prompt 4.
Reason I ask is that an awful lot of times I start typing a ...
Bug - Can't seem to refresh cache after deleting for DB?
This is an odd behaviour - using the latest release of SQL Prompt 3.6. I was trying to refresh the cache of an existing database and kept getting a problem with the security - a context error that...
Bug - SQL Prompt 3.6.0.82 - aliases prompt for connections
This was around in 3.5 as well. When I type a new query:
SELECT * from MyTable as m
where m. <-- Problem occurs here
I get a prompt to log in to "m" or "Server.m". I hit Escape, go back and hit...
Feature Request - Sort columns by physical order?
We seem to be only able to sort columns by name right now. Is there an option I'm missing to sort columns by the physical order in the table? For instance, I have a Contribution_ID and a Contribu...
Feature Request - disable SQL Prompt for specific apps
I was also bitten by the Data Dude lack of support - in my case, I get a neverending error box that only allows me to "Continue". I do most of my work in SSMS, tweaking, etc and don't really see t...
[BUG] Table Aliases prompt for authentication
Using 3.5 release. I am still prompted for authentication when I use table aliases for the first time. Example:
SELECT *
FROM Table1 as t1
WHERE t1. <-- this is where I am prompted for authentica...
3.5 RC Initial Impressions
I like:
Cross-database queries - looks like they are working again!
Speed improvements - quite a few. I can replace a value now without going to make a pot of coffee.
Refresh Cache hot-key - much ...