Search code examples
sqlsql-serverssmscode-snippetsssms-2014

Can't find my snippets in ctrl K/X in SSMS


I imported them in this windows : https://i.sstatic.net/sl2EC.jpg

but I can't find them in : https://i.sstatic.net/d6P2l.jpg

Any idea why ? It's a fresh install of SSMS (and windows). Worked before.


Solution

  • can you verify that in the definition of your snippets, you have sections like:

    <SnippetTypes>
      <SnippetType>SurroundsWith</SnippetType>
    </SnippetTypes>
    

    and/or

    <SnippetTypes>
      <SnippetType>Expansion</SnippetType>
    </SnippetTypes>
    

    This indicate where the snippets can and will be used from. Source: SQL SERVER 2014 Code Snippets missing