Object schema not available from tool tip

GunNut37086GunNut37086 Posts: 9 Bronze 2
edited September 11, 2017 3:25PM in SQL Prompt
In Management Studio I used to be able to hover over an object in a query window, like a table, and click the link to see the schema information. With my current version (8.0.6.188) the link shows up when I hover, but nothing happens when I click it.

I really liked this feature and used it daily. Was it removed? Is there something wrong with my installation?

Comments

  • more info: this is the feature I'm trying to use:

    http://documentation.red-gate.com/display/SP6/Using+the+object+definition+box+and+object+tooltips

    Nothing happens when I click the object name to do display the object definition box.
  • Hi @GunNut37086,
    could you please send us the screenshot of the tooltip you're getting?

    The right documentation link for your version is this one.
    As the note states, you can turn off the box, following the instructions in the Showing or hiding the object definition box section.

    If you've accidentally turned it off, you should see the SSMS toolbox, if the SSMS intellisense is on, or even nothing.
    Alessandro Alpi
    CTO @ Engage IT Services s.r.l.
    Database Administrator and Team Leader
    Microsoft MVP - Data Platform
    Staff member of getlatestversion.it community
    personal website | blog
  • GunNut37086GunNut37086 Posts: 9 Bronze 2
    edited August 23, 2017 6:01PM
    Previously I was able to hover over the table name in a query and SQL Prompt would show a tool tip. I could click on the fully qualified object name in the tool tip (circled in red below) and an object definition box would appear, like the documentation says. However, when I click on the tool tip, it just goes away without displaying the object definition box.

    y8ftv5odvqzh.png

    If I were helping someone with this issue, my next question would be "Have you checked your settings?" In the screenshot below, circled in red, is the checkbox that controls this feature.Edit: as you can see in my settings, the feature is enabled like the directions suggest, but the feature still doesn't work.

    3hke9l2qyu2z.png

  • So is it working now? I didn't get :-)
    Alessandro Alpi
    CTO @ Engage IT Services s.r.l.
    Database Administrator and Team Leader
    Microsoft MVP - Data Platform
    Staff member of getlatestversion.it community
    personal website | blog
  • GunNut37086GunNut37086 Posts: 9 Bronze 2
    edited August 23, 2017 6:01PM
    @AlessandroAlpi Sorry, I'm missing the part that's confusing you. The tool tip in the first pic pops up when you hover over a table name. When I click on the tool tip, the tool tip disappears and nothing happens. clicking the tool tip supposed to open an Object Definition Box like in the pic below.
    znll7hi0bsn4.png
  • AlessandroAlpiAlessandroAlpi Posts: 91 Gold 2
    edited August 23, 2017 9:22PM
    So, despite you've the setting "show object definition" turned on, you cannot get the tooltip yet.
    You can try the following:
    - turn the setting off, restart SSMS, be sure that the tooltip not appears, turn the setting ON, restart SSMS and retry
    - turn SQL Prompt off (disabling it), restart SSMS, turn it ON, restart SSMS and retry
    - disable the SQL Server intellisense (you can do it from the Query menu)

    doing that, you can look for the SQL Prompt log files.
    what version of SSMS are you working on?
    Alessandro Alpi
    CTO @ Engage IT Services s.r.l.
    Database Administrator and Team Leader
    Microsoft MVP - Data Platform
    Staff member of getlatestversion.it community
    personal website | blog
  • Hi @GunNut37086,

    Sorry for the inconvenience. What version of SSMS are you using? Can you send us logs (You can find them by a link which @AlessandroAlpi attached above)?

    Best regards,
    Krzysztof
  • BCMBCM Posts: 1 New member
    edited September 5, 2017 2:48PM
    We were also experiencing this issue but upgrading to latest SQL Prompt seems to have resolved it.
  • @krzysztofkroczak I'm running version 11.0.2100.60, which is SSMS 2012 and 13.0.16.106.4, which is SSMS 2016. The tool tip pops up in both, but the when I click on the tool tip the object definition box does not open in either.
  • 05 Sep 2017 17:38:30,603 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt 8.0.6.1888 editor session
    05 Sep 2017 17:38:31,557 [9] INFO RedGate.SQLPrompt.CommonUI.Options.SqlPromptApplication - Initialized: RedGate.SQLPrompt.CommonUI.External.SharedControls.Controls.InteractiveHelp.ConvertHtml2Rtf.Html2Rtf
    05 Sep 2017 17:38:31,726 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading UIOptions from C:\Users\kdurham\AppData\Local\Red Gate\SQL Prompt 8\RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml (attempt 0 of 10)...
    05 Sep 2017 17:38:31,787 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded UIOptions
    05 Sep 2017 17:38:31,848 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading EngineOptions from C:\Users\kdurham\AppData\Local\Red Gate\SQL Prompt 8\RedGate_SqlPrompt_Engine_EngineOptions.xml (attempt 0 of 10)...
    05 Sep 2017 17:38:31,872 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded EngineOptions
    05 Sep 2017 17:38:31,897 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading LayoutOptions from C:\Users\kdurham\AppData\Local\Red Gate\SQL Prompt 8\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml (attempt 0 of 10)...
    05 Sep 2017 17:38:31,915 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded LayoutOptions
    05 Sep 2017 17:38:31,930 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading TabMagicOptions from C:\Users\kdurham\AppData\Local\Red Gate\SQL Prompt 8\RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml (attempt 0 of 10)...
    05 Sep 2017 17:38:31,943 [1] INFO RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded TabMagicOptions
    05 Sep 2017 17:38:31,964 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - BaseConnect(RedGate.SQLPrompt.SsmsPackage.ConnectAdapter) constructed successfully
    05 Sep 2017 17:38:32,214 [1] INFO RedGate.SQLQueryKeeper.TabMagicConnect2016 - ctor started
    05 Sep 2017 17:38:32,219 [1] INFO RedGate.SQLQueryKeeper.TabMagicConnect2016 - ctor complete
    05 Sep 2017 17:38:32,263 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Initialising DTE and AddIn connections.
    ***
    DTE.FullName = C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe, DTE.Version = 2015.0130,
    DTE.CommandLine = ,
    ***
    AddIn.Name = SQL Prompt, AddIn.ProgID = RedGate.SQLPrompt.SsmsPackage.ConnectAdapter,
    AddIn.Description = SQL Prompt
    05 Sep 2017 17:38:32,268 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Current culture en-US
    05 Sep 2017 17:38:32,276 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - AddIn.SatelliteDllPath =
    05 Sep 2017 17:38:33,089 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Initialisation successful.
    05 Sep 2017 17:38:33,207 [1] INFO RedGate.SQLQueryKeeper.TabMagicConnect2016 - Initialize started
    05 Sep 2017 17:38:33,215 [1] INFO RedGate.SQLQueryKeeper.Initialization - Connecting
    05 Sep 2017 17:38:33,435 [1] INFO RedGate.SQLQueryKeeper.MutexWrapper - Taking mutex for DocumentStore ctorf7b16630-c1dc-4386-b951-944887228e7b
    05 Sep 2017 17:38:33,464 [1] INFO RedGate.SQLQueryKeeper.MutexWrapper - Releasing mutex for DocumentStore ctorf7b16630-c1dc-4386-b951-944887228e7b
    05 Sep 2017 17:38:33,472 [1] INFO RedGate.SQLQueryKeeper.TabMagicConnect2016 - Initialize complete
    05 Sep 2017 17:38:33,479 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - OnConnection(ext_cm_AfterStartup)
    05 Sep 2017 17:38:33,488 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Handling OnStartupComplete()
    05 Sep 2017 17:38:33,502 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Entering Startup()
    05 Sep 2017 17:38:33,509 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Loading plugins...
    05 Sep 2017 17:38:33,517 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Starting EditorManager...
    05 Sep 2017 17:38:33,586 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Creating menus for SQL Prompt edition Full
    05 Sep 2017 17:38:33,927 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Calling SqlPromptApplication.Initialise()
    05 Sep 2017 17:38:33,966 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Startup() completed successfully.
    05 Sep 2017 17:38:33,985 [1] INFO RedGate.SQLPrompt.CommonVS.BaseConnect.1 - SqlPromptApplication initialised. (startup took 0:00:03.663)
    05 Sep 2017 17:38:34,004 [1] INFO RedGate.SQLQueryKeeper.TabMagicConnect2016 - OnStartupComplete started
    05 Sep 2017 17:38:34,012 [1] INFO RedGate.SQLQueryKeeper.Initialization - OnShellInitialized
    05 Sep 2017 17:38:34,019 [1] INFO RedGate.SQLQueryKeeper.MutexWrapper - Taking mutex for Reload open tabs78da7401-2721-47db-a79d-36c53542e502
    05 Sep 2017 17:38:34,090 [1] INFO RedGate.SQLQueryKeeper.MutexWrapper - Releasing mutex for Reload open tabs78da7401-2721-47db-a79d-36c53542e502
    05 Sep 2017 17:38:34,095 [1] INFO RedGate.SQLQueryKeeper.TabMagicConnect2016 - OnStartupComplete complete
    05 Sep 2017 17:39:36,697 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Document opened
    05 Sep 2017 17:39:37,630 [1] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Created new ServerCandidate for server: mncedi01
    05 Sep 2017 17:39:37,924 [35] INFO RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities Sql2012
    05 Sep 2017 17:39:38,333 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Connecting...
    05 Sep 2017 17:39:38,586 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [mncedi01].[master] as Sql2012
    05 Sep 2017 17:39:38,685 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing schemas...
    05 Sep 2017 17:39:38,691 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing objects...
    05 Sep 2017 17:39:38,793 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing master objects...
    05 Sep 2017 17:39:38,810 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing triggers...
    05 Sep 2017 17:39:38,817 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing datatypes...
    05 Sep 2017 17:39:39,243 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing datatypes...
    05 Sep 2017 17:39:39,277 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing columns...
    05 Sep 2017 17:39:39,324 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing parameters...
    05 Sep 2017 17:39:39,436 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing indexes...
    05 Sep 2017 17:39:39,447 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing foreign keys...
    05 Sep 2017 17:39:39,457 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing primary keys...
    05 Sep 2017 17:39:39,466 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing services...
    05 Sep 2017 17:39:39,475 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing contracts...
    05 Sep 2017 17:39:39,484 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing contracts...
    05 Sep 2017 17:39:39,493 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing routes...
    05 Sep 2017 17:39:39,502 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing xml schema collections...
    05 Sep 2017 17:39:39,511 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing filegroups...
    05 Sep 2017 17:39:39,520 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing roles...
    05 Sep 2017 17:39:39,531 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing users...
    05 Sep 2017 17:39:39,542 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing default schema...
    05 Sep 2017 17:39:39,549 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing synonyms...
    05 Sep 2017 17:39:39,556 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Processing descriptions...
    05 Sep 2017 17:39:39,578 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Indexing all database columns
    05 Sep 2017 17:39:39,588 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] progress: Fetching script information
    05 Sep 2017 17:39:39,728 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Waiting for master database
    05 Sep 2017 17:39:40,405 [41] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[master] Cache finished with no warnings
    05 Sep 2017 17:39:40,440 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Connecting...
    05 Sep 2017 17:39:40,725 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - Populating [mncedi01].[EDI] as Sql2012
    05 Sep 2017 17:39:40,800 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing schemas...
    05 Sep 2017 17:39:40,806 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing objects...
    05 Sep 2017 17:39:40,840 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing master objects...
    05 Sep 2017 17:39:40,851 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing triggers...
    05 Sep 2017 17:39:40,857 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing datatypes...
    05 Sep 2017 17:39:40,866 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing datatypes...
    05 Sep 2017 17:39:40,874 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing columns...
    05 Sep 2017 17:39:41,364 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing parameters...
    05 Sep 2017 17:39:41,456 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing indexes...
    05 Sep 2017 17:39:41,614 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing foreign keys...
    05 Sep 2017 17:39:41,640 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing primary keys...
    05 Sep 2017 17:39:41,650 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing services...
    05 Sep 2017 17:39:41,658 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing contracts...
    05 Sep 2017 17:39:41,667 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing contracts...
    05 Sep 2017 17:39:41,674 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing routes...
    05 Sep 2017 17:39:41,679 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing xml schema collections...
    05 Sep 2017 17:39:41,685 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing filegroups...
    05 Sep 2017 17:39:41,690 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing roles...
    05 Sep 2017 17:39:41,696 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing users...
    05 Sep 2017 17:39:41,701 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing default schema...
    05 Sep 2017 17:39:41,706 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing synonyms...
    05 Sep 2017 17:39:41,712 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Processing descriptions...
    05 Sep 2017 17:39:41,724 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Indexing all database columns
    05 Sep 2017 17:39:41,733 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] progress: Fetching script information
    05 Sep 2017 17:39:42,431 [35] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] Cache finished with no warnings
    05 Sep 2017 17:39:45,356 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Query executed
    05 Sep 2017 17:39:49,271 [1] INFO RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidateBase - [mncedi01].[EDI] loading skipped
  • @krzysztofkroczak there's the log you wanted to see
  • a new update just became available from RG that fixed the issue for me too...this is solved
  • AlessandroAlpiAlessandroAlpi Posts: 91 Gold 2
    edited September 5, 2017 9:59PM
    Glad to get it! :D
    Alessandro Alpi
    CTO @ Engage IT Services s.r.l.
    Database Administrator and Team Leader
    Microsoft MVP - Data Platform
    Staff member of getlatestversion.it community
    personal website | blog
Sign In or Register to comment.