Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Keyword inserted when enter clicked on alias |
|
v 5.2.29 SQL
 |
 |
SELECT d.name, d.is_cdc_enabled
FROM sys.databases d |
Place the cursor next to d and hit enter. d is replaced with DELETE. I've also seen it with c getting changed to CROSS APPLY.
|
|
Tue Apr 05, 2011 1:25 pm |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2170
|
|
|
|
It might be because I've altered most of the settings but I don't experience this issue. You don't have snippets d for DELETE and c for CROSS APPLY with ENTER as Key Char, do you?
|
|
Tue Apr 05, 2011 6:31 pm |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
no, no snippets for that. In fact, DB options are: SQL Keywords no, Suggest after: 2. But it is checked on History. Pretty odd.
|
|
Wed Apr 06, 2011 8:52 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7966
|
|
|
|
Please check if any snippets have "Enter" key set as their trigger.
|
|
Wed Apr 06, 2011 9:39 am |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
 |
 |
But it is checked on History. |
Referring the SQL Keywords: Should be "But it is checked on List Items"
Everything is triggered by Ctrl-Enter, except the built in begin and begin try.
|
|
Wed Apr 06, 2011 10:10 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7966
|
|
|
|
Please try disabling history cache/prompts to exclude their interference (Options dialog -> DB Options -> SQL Server -> History -> History Items Shown in Lists -> 0). When disabled, cached historical items shouldn't appear in the green portion of popups.
Sorry for a silly question, you don't have any other add-on or feature enabled outside SQL Assistant that might be expanding d into DEELTE when Enter key is pressed?
|
|
Thu Apr 07, 2011 8:11 am |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
History was already disabled (since its release). But yes, it was SSMS Tools that did it. It has it's own snippet thing. I usually keep it disabled. Don't know how it got reenabled, unless it was an upgrade of their software that blew away my settings.
|
|
Thu Apr 07, 2011 12:16 pm |
|
 |
|