Friday 15 May 2015

sql server - Add "Available Databases" dropdown to custom toolbar in SSMS -


I create a custom toolbar in Ssms I "from database" may add dropdown that SQL editor toolbar on my custom toolbar But I do not know how to add it. It does not appear in the command list.

The only way that I could do it (Ssms using 2016) directly .vssettings was playing with the file. I had to first identify the GUID for the available databases command to remove it from the SQL Editor toolbar and export the settings. It has the & lt; Remove CMD ... & gt; Enter . Then I can use GUID to add it to my custom toolbar as follows:

   & Lt; Adding Cmd = "{52692960-56BC-4989-B5D3-94C47A513E8D}: 00000004" CmdPri = "40,000,001" group = "{8D3759E8-C5F6-4C93-B672-43B89D8479A5}: 00,000,202" GroupPri = "40,000,001" menu = "{8D3759E8 -C5F6-4C93-B672-43B89D8479A5}: 00,000,602 "/> & Lt; / UserCustomizations & gt; & Lt; / CommandBars & gt; & Lt; / Category & gt;   

Up not changes that are key points cmd = "{...}" and Simdeepi = ". .. ". When creating custom toolbar, group , GroupPri and menu value are assigned to all (and export settings).

Then when you import the modified settings file, your customer toolbar should have a available database drop-down combo box!

No comments:

Post a Comment