SQL Prompt 6.4.0.633 Issues

nhustaknhustak Posts: 41
edited September 26, 2014 7:33AM in SQL Prompt
Hi,
Having an issue with getting SQL Prompt to 'boot'. I am finding that when I first open a SSMS and go into a query that intellisense fails to function unless I manually select 'refresh suggestions'.

I have double checked my configuration - I am experiencing this on both my work & home workstations.

The automatic refresh suggestions experimental option also no longer works or at least it is erratic.

The pop up window is also gone that use to show it initializing.

Regards,
Nick H

Comments

  • Actually it looks like the automatic refresh AFTER I have manually done a refresh suggestions seems to work.

    Really miss the pop up 'working' window.
  • Aaron LAaron L Posts: 596 New member
    Hi Nick,

    I'm trying to recreate this on our test machine but I'm not having much luck (prompt is kicking in immediately, with a loading dialog) could I ask which version of SSMS you're running and also which server version you're connecting to?

    Also, could you check if there's any warnings or errors logged that might be affecting the first refresh under SQL Prompt->Help->Show Log

    Thanks,
    Aaron.
  • I haven't seen the loading prompt since I swapped to the beta last week.

    Here's a dump from SSMS:

    Microsoft SQL Server Management Studio 11.0.5058.0
    Microsoft Analysis Services Client Tools 11.0.5058.0
    Microsoft Data Access Components (MDAC) 6.1.7601.17514
    Microsoft MSXML 3.0 6.0
    Microsoft Internet Explorer 9.11.9600.17280
    Microsoft .NET Framework 4.0.30319.18444
    Operating System 6.1.7601

    Here's the SQL Promprt Log:

    25 Sep 2014 11:47:02,219 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
    25 Sep 2014 11:47:02,291 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading UIOptions from C:Users
    jhAppDataLocalRed GateSQL Prompt 6RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml (attempt 0 of 10)...
    25 Sep 2014 11:47:02,523 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded UIOptions
    25 Sep 2014 11:47:02,546 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading EngineOptions from C:Users
    jhAppDataLocalRed GateSQL Prompt 6RedGate_SqlPrompt_Engine_EngineOptions.xml (attempt 0 of 10)...
    25 Sep 2014 11:47:02,563 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded EngineOptions
    25 Sep 2014 11:47:02,582 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading LayoutOptions from C:Users
    jhAppDataLocalRed GateSQL Prompt 6RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml (attempt 0 of 10)...
    25 Sep 2014 11:47:02,591 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded LayoutOptions
    25 Sep 2014 11:47:02,598 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading TabMagicOptions from C:Users
    jhAppDataLocalRed GateSQL Prompt 6RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml (attempt 0 of 10)...
    25 Sep 2014 11:47:02,604 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded TabMagicOptions
    25 Sep 2014 11:47:02,618 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - BaseConnect(RedGate.SQLPrompt.SSMSUI.Connect2011) constructed successfully
    25 Sep 2014 11:47:02,676 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - OnConnection(ext_cm_Startup)
    25 Sep 2014 11:47:02,685 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Initialising DTE and AddIn connections.
    ***
    DTE.FullName = C:Program Files (x86)Microsoft SQL Server110ToolsBinnManagementStudioSsms.exe, DTE.Version = 2011.0110,
    DTE.CommandLine = ,
    ***
    AddIn.Name = SQL Prompt 6, AddIn.ProgID = RedGate.SQLPrompt.SSMSUI.Connect2011,
    AddIn.Description = SQL Prompt 6 (6.4.0.633) - Write, edit, and explore SQL effortlessly
    25 Sep 2014 11:47:02,687 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Current culture en-US
    25 Sep 2014 11:47:02,710 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - AddIn.SatelliteDllPath = C:Program Files (x86)Red GateSQL Prompt 6enRedGate.SQLPrompt.SSMSUIfw4.resources.dll
    25 Sep 2014 11:47:02,801 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Initialise successful.
    25 Sep 2014 11:47:03,227 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - DoUiSetup() - recreating commands and cleaning up obsolete commands
    25 Sep 2014 11:47:03,634 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - DoUiSetup() complete.
    25 Sep 2014 11:47:05,342 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Handling OnStartupComplete()
    25 Sep 2014 11:47:05,375 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Entering Startup()
    25 Sep 2014 11:47:05,378 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Loading plugins...
    25 Sep 2014 11:47:05,475 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Starting EditorManager...
    25 Sep 2014 11:47:05,494 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Creating menus for SQL Prompt edition Full
    25 Sep 2014 11:47:05,948 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Calling SqlPromptApplication.Initialise()
    25 Sep 2014 11:47:05,968 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Startup() completed successfully.
    25 Sep 2014 11:47:05,972 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - SqlPromptApplication initialised. (startup took 0:00:03.833)
  • Aaron LAaron L Posts: 596 New member
    Thanks Nick,

    The log all looks normal to me. I think I may have just been able to recreate this here too. It looks like it's related to the auto-refresh experimental feature. If you disable that feature for now does Prompt work as expected for you?

    Thanks,
    Aaron.
  • Aaron,
    That fixed the not working part on startup. I still have no progress window.
    Nick
  • Aaron LAaron L Posts: 596 New member
    Thanks for confirming that's the issue Nick, we think we've located the source of the problem and should hopefully have a fix for you tomorrow.

    As for the progress dialog, is it possible that it's just appearing/disappearing quickly on a fast loading database? If you hold down ctrl+shift+D do you see it flickering in the bottom right hand corner of the query window?

    Thanks,
    Aaron.
  • Aaron,
    Happy to help. Cool you guys found it. No, on the progress - I am hooking to an offsite database over a VPN. It use to take it a couple of seconds to process it. There's definitely no flash.
    Nick
  • Aaron LAaron L Posts: 596 New member
    Hi Nick,

    I've just updated Prompt to 6.4.0.650 which should have a fix for both the auto-refresh bug and for the progress dialog not being displayed. Please give it a try and let us know if it works for you.

    Thanks,
    Aaron.
Sign In or Register to comment.